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.