PlotVisibleOnly Property
Applies To
Chart object.
Description
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