Edit

Chart.DisplayBlanksAs property (Project)

  • Article

Gets or sets the way that blank cells are plotted on a chart. Can be one of the Office.XlDisplayBlanksAs constants. Read/write Long.

Syntax

expression.DisplayBlanksAs

expression A variable that represents a Chart object.

Example

The following example hides blank cells in the chart.

Sub HideBlankCells()
    Dim chartShape As Shape
    Dim reportName As String
    
    reportName = "Simple scalar chart"
    Set chartShape = ActiveProject.Reports(reportName).Shapes(1)
    
    chartShape.Chart.DisplayBlanksAs = Office.XlDisplayBlanksAs.xlNotPlotted
End Sub

Property value

XLDISPLAYBLANKSAS

See also

Chart Object

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.