GrapeCity.Documents.Excel.Drawing.IPoint.InvertIfNegative

InvertIfNegative Property

InvertIfNegative

Gets or sets whether Microsoft Excel inverts the pattern for this point when it corresponds to a negative number.

When this property is true, the point uses the inverted pattern if its value is negative.

Declaration

bool InvertIfNegative { get; set; }

Property InvertIfNegative As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {{"Month", "Amount"}, {"Jan", 12}, {"Feb", -8}, {"Mar", 15}};
IChart chart = worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200).Chart;
chart.SeriesCollection.Add(worksheet.Range["A1:B4"]);
IPoint point = chart.SeriesCollection[0].Points[1];
point.InvertIfNegative = true;
bool invertIfNegative = point.InvertIfNegative;