Class Legend (Excel VBA)

The class Legend represents the legend in a chart. Each chart can have only one legend.

The main procedures of class Legend are Delete and Select

Methods

These are the main methods of the Legend class

Delete - Deletes the object.

Select - Selects the object.

Properties

Format returns the ChartFormat object.

Height returns or sets a Double value that represents the height, in points, of the object.

IncludeInLayout true if a legend will occupy the chart layout space when a chart layout is being determined. The default value is True.

Left returns or sets a Double value that represents the distance, in points, from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart).

Name returns a String value that represents the name of the object.

Parent returns the parent object for the specified object. Read-only.

Position returns or sets an XlLegendPosition value that represents the position of the legend on the chart.

Charts(1).Legend.Position = xlLegendPositionBottom

Shadow returns or sets a Boolean value that determines if the object has a shadow.

Top returns or sets a Double value that represents the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).

Width returns or sets a Double value that represents the width, in points, of the object.