ShowVisibleOnly Property

The ShowVisibleOnly property returns or sets the show visible plots only flag for legend entries. Returns a Boolean.

Syntax

object.ShowVisibleOnly

object.ShowVisibleOnly = ShowVisibleOnly

 

Parameter Type Description
ShowVisibleOnly Boolean required, true to only display legend entries for visible plots

 

Remarks

The legend entries update automatically as plots are made visible or invisible.

Example 1

The following example demonstrates how to return the show visible plots only state

Debug.Print Legend.ShowVisibleOnly

Example 2

The following example demonstrates how to show legend entries for visible plots only.

Legend.ShowVisibleOnly = True

 

Used by: AutoLegend Object