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
Enable both hidden and visible rows to plot? plot visible only Plot Visible Only Property plotvisible PlotVisibleOnly PlotVisibleOnly Property PlotVisibleOnly? Prevent Excel from including invisible cells in my plot? Switch for graphing only visible data?

See also: