Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the way that blank cells are plotted on a chart.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Property DisplayBlanksAs As XlDisplayBlanksAs
XlDisplayBlanksAs DisplayBlanksAs { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlDisplayBlanksAs
One of the following XlDisplayBlanksAs values: xlNotPlotted, xlInterpolated, or xlZero.
Examples
The following code example creates a Chart and then uses the DisplayBlanksAs property to specify that blank cells are not plotted in the data range of the chart.
Private Sub DisableBlankPlotting()
' Note that the following data ranges are missing
' values in A5 and B1.
Me.Range("A1", "A4").Value2 = 22
Me.Range("B2", "B5").Value2 = 55
Dim Chart1 As Microsoft.Office.Tools.Excel.Chart = _
Me.Controls.AddChart(Me.Range("D2", "H12"), "Chart1")
Chart1.SetSourceData(Me.Range("A1", "B5"), Excel.XlRowCol.xlColumns)
Chart1.ChartType = Excel.XlChartType.xl3DColumn
Chart1.DisplayBlanksAs = Excel.XlDisplayBlanksAs.xlNotPlotted
End Sub
private void DisableBlankPlotting()
{
// Note that the following data ranges are
// missing values in A5 and B1.
this.Range["A1", "A4"].Value2 = 22;
this.Range["B2", "B5"].Value2 = 55;
Microsoft.Office.Tools.Excel.Chart chart1 =
this.Controls.AddChart(this.Range["D2", "H12"],
"chart1");
chart1.SetSourceData(this.Range["A1", "B5"],
Excel.XlRowCol.xlColumns);
chart1.ChartType = Excel.XlChartType.xl3DColumn;
chart1.DisplayBlanksAs =
Excel.XlDisplayBlanksAs.xlNotPlotted;
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.