Legend.LegendEntries Method (Excel)
Returns an object that represents either a single legend entry (a LegendEntry object) or a collection of legend entries (a LegendEntries object) for the legend.
Syntax
expression .LegendEntries(Index)
expression A variable that represents a Legend object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Index |
Optional |
Variant |
The number of the legend entry. |
Return Value
Object
Example
This example sets the font for legend entry one on Chart1.
Charts("Chart1").Legend.LegendEntries(1).Font.Name = "Arial"