Legend Members (Excel)

Represents the legend in a chart. Each chart can have only one legend.

Methods

Name

Description

Clear

Clears the entire object.

Delete

Deletes the object.

LegendEntries

Returns an object that represents either a single legend entry (a LegendEntry object) or a collection of legend entries (a LegendEntries object) for the legend.

Select

Selects the object.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

Format

Returns the ChartFormat object. Read-only.

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. Read/write Boolean.

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 a XlLegendPosition value that represents the position of the legend on the chart.

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.