LegendEntries Object

Remarks

Each legend entry has two parts: the text of the entry, which is the name of the series or trendline associated with the legend entry; and the entry marker, which visually links the legend entry with its associated series or trendline in the chart. The formatting properties for the entry marker and its associated series or trendline are contained in the LegendKey object.

Example

Use the LegendEntries method to return the LegendEntries collection. The following example loops through the collection of legend entries in embedded chart one and changes their font color.

With Worksheets("sheet1").ChartObjects(1).Chart.Legend For i = 1 To .LegendEntries.Count .LegendEntries(i).Font.ColorIndex = 5 Next End With

Use LegendEntries(), where is the legend entry index number, to return a single LegendEntryobject. You cannot return legend entries by name.

The index number represents the position of the legend entry in the legend. LegendEntries(1) is at the top of the legend; LegendEntries(LegendEntries.Count) is at the bottom. The following example changes the font style for the text of the legend entry at the top of the legend (this is usually the legend for series one) in embedded chart one to italic.

Worksheets("sheet1").ChartObjects(1).Chart _ .Legend.LegendEntries(1).Font.Italic = True

See also:

• Excel Object Model Reference
• LegendEntries Object Members