ShowVisibleEntriesOnly Property

The ShowVisibleEntriesOnly property returns or sets the show visible plots only flag for color and symbol table legend entries. Returns a Boolean.

Syntax

object.ShowVisibleEntriesOnly

object.ShowVisibleEntriesOnly = ShowVisibleEntriesOnly

 

Parameter Type Description
ShowVisibleEntriesOnly 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.ShowVisibleEntriesOnly

Example 2

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

Legend.ShowVisibleEntriesOnly = True

 

Used by: AutoLegend Object