GrapeCity.Documents.Excel.DisplayBlanksAs

DisplayBlanksAs Enum

Specifies how blank cells are plotted on a chart.

Use this enumeration with chart and sparkline blank-cell display settings to control whether blank cells are shown as gaps, zero values, or interpolated values.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum DisplayBlanksAs

Public Enum DisplayBlanksAs

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Month", "Sales"},
    {"Jan", 10},
    {"Feb", null},
    {"Mar", 20}
};
IShape shape = worksheet.Shapes.AddChart(ChartType.Line, 200, 20, 300, 200);
shape.Chart.SeriesCollection.Add(worksheet.Range["A1:B4"], RowCol.Columns, true, true);
shape.Chart.DisplayBlanksAs = DisplayBlanksAs.Zero;

Fields

Name	Description
Interpolated	Specifies that values are interpolated into the chart.
NotPlotted	Specifies that blank cells are not plotted.
Zero	Specifies that blanks are plotted as zero.