Chart.PlotVisibleOnly (Excel)

True if only visible cells are plotted. False if both visible and hidden cells are plotted.

ActiveChart.PlotVisibleOnly = True