LegendKey object (Excel)

Represents a legend key in a chart legend.

Remarks

Each legend key is a graphic that visually links a legend entry with its associated series or trendline in the chart. The legend key is linked to its associated series or trendline in such a way that changing the formatting of one simultaneously changes the formatting of the other.

Example

Use the LegendKey property of the LegendEntry object to return the LegendKey object.

The following example changes the marker background color for the legend entry at the top of the legend for embedded chart one on the worksheet named Sheet1. This simultaneously changes the format of every point in the series associated with this legend entry. The associated series must support data markers.

Worksheets("sheet1").ChartObjects(1).Chart _ 
 .Legend.LegendEntries(1).LegendKey.MarkerBackgroundColorIndex = 5

Methods

• ClearFormats
• Delete

Properties

• Application
• Creator
• Format
• Height
• InvertIfNegative
• Left
• MarkerBackgroundColor
• MarkerBackgroundColorIndex
• MarkerForegroundColor
• MarkerForegroundColorIndex
• MarkerSize
• MarkerStyle
• Parent
• PictureType
• PictureUnit2
• Shadow
• Smooth
• Top
• Width

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.