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