LegendKey Object [Excel 2003 VBA Language Reference]

  • Article
LegendEntry
LegendKey
Multiple objects

Represents a legend key in a chart legend. 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.

Using the LegendKey Object

Use the LegendKey property 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

Properties | Application Property | Border Property | Creator Property | Fill Property | Height Property | Interior Property | InvertIfNegative Property | Left Property | MarkerBackgroundColor Property | MarkerBackgroundColorIndex Property | MarkerForegroundColor Property | MarkerForegroundColorIndex Property | MarkerSize Property | MarkerStyle Property | Parent Property | PictureType Property | PictureUnit Property | Shadow Property | Smooth Property | Top Property | Width Property

Methods | ClearFormats Method | Delete Method | Select Method

Parent Objects | LegendEntry Object

Child Objects | Border Object | ChartFillFormat Object | Interior Object