Chart.PlotVisibleOnly Property

  • Article
Excel Developer Reference

True if only visible cells are plotted. False if both visible and hidden cells are plotted. Read/write Boolean.

Syntax

expression.PlotVisibleOnly

expression   A variable that represents a Chart object.

Example

This example causes Microsoft Excel to plot only visible cells in Chart1.

Visual Basic for Applications 
  Charts("Chart1").PlotVisibleOnly = True

See Also