Chart.PlotVisibleOnly Property (Excel)
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.
Charts("Chart1").PlotVisibleOnly = True