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 Microsoft.Office.Tools.Excel.ChartSheet.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Property DisplayBlanksAs As XlDisplayBlanksAs
Get
Set
XlDisplayBlanksAs DisplayBlanksAs { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlDisplayBlanksAs
One of the following XlDisplayBlanksAs constants: xlNotPlotted, xlInterpolated, or xlZero.
Examples
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 Sub 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
Me.SetSourceData(Globals.Sheet1.Range("A1", "B5"), _
Excel.XlRowCol.xlColumns)
Me.ChartType = Excel.XlChartType.xl3DBarClustered
Me.DisplayBlanksAs = Excel.XlDisplayBlanksAs.xlNotPlotted
End Sub
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;
}
.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.