PlotVisibleOnly Property

Microsoft Excel Visual Basic

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

Example

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

Charts("Chart1").PlotVisibleOnly = True