GrapeCity.Documents.Excel.ISparklineGroup.DisplayBlanksAs

DisplayBlanksAs Property

DisplayBlanksAs

Gets or sets the way that blank cells are plotted in the sparkline group.

Use this property to determine how blank values in the sparkline source data are displayed for the sparkline group.

Declaration

DisplayBlanksAs DisplayBlanksAs { get; set; }

Property DisplayBlanksAs As DisplayBlanksAs

Examples

worksheet.Range["A1:C1"].Value = new object[] {1, null, 2};
ISparklineGroup group = worksheet.Range["D1"].SparklineGroups.Add(SparkType.Line, "A1:C1");
group.DisplayBlanksAs = DisplayBlanksAs.Zero;
DisplayBlanksAs blanksAs = group.DisplayBlanksAs;