Chart.PlotVisibleOnly Property

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

• Chart Object
• Chart Object Members