GrapeCity.Documents.Excel.Drawing.ISeries.InvertIfNegative

InvertIfNegative Property

InvertIfNegative

Gets or sets whether Microsoft Excel inverts the pattern in the series when a data point corresponds to a negative number.

When this property is true, negative data points in the series use the inverted pattern. This setting can be used together with InvertColor to control the appearance of negative values.

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"]);
ISeries series = chart.SeriesCollection[0];
series.InvertIfNegative = true;
bool invertIfNegative = series.InvertIfNegative;