Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
DisplayBlanksAs Property

ChartSheet.DisplayBlanksAs Property

Gets or sets the way that blank cells are plotted on a Microsoft.Office.Tools.Excel.ChartSheet.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

public virtual XlDisplayBlanksAs DisplayBlanksAs { get; set; }

Property Value

One of the following XlDisplayBlanksAs constants: xlNotPlotted, xlInterpolated, or xlZero.

The following code example uses the DisplayBlanksAs property to specify that the current Microsoft.Office.Tools.Excel.ChartSheet does not plot blank cells in the data range.

private void DoNotPlotBlanks()
{
    // Note that the following data ranges are missing 
    // values in A5 and B1.
    Globals.Sheet1.Range["A1", "A4"].Value2 = 22;
    Globals.Sheet1.Range["B2", "B5"].Value2 = 55;

    this.SetSourceData(Globals.Sheet1.Range["A1", "B5"],
        Excel.XlRowCol.xlColumns);
    this.ChartType = Excel.XlChartType.xl3DBarClustered;
    this.DisplayBlanksAs = Excel.XlDisplayBlanksAs.xlNotPlotted;
}

Show:
© 2015 Microsoft