LegendKey Properties (Excel)

Article
05/23/2016

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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 a Double value that represents the height, in points, of the object.
InvertIfNegative	True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. Read/write Boolean.
Left	Returns a Double value that represents the distance, in points, from the left edge of the object to the left edge of the chart area.
MarkerBackgroundColor	Sets the marker background color as an RGB value or returns the corresponding color index value. Applies only to line, scatter, and radar charts. Read/write Long.
MarkerBackgroundColorIndex	Returns or sets the marker background color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts. Read/write Long.
MarkerForegroundColor	Sets the marker foreground color as an RGB value or returns the corresponding color index value. Applies only to line, scatter, and radar charts. Read/write Long.
MarkerForegroundColorIndex	Returns or sets the marker foreground color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts. Read/write Long.
MarkerSize	Returns or sets the data-marker size, in points. Can be a value from 2 through 72. Read/write Long.
MarkerStyle	Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart. Read/write XlMarkerStyle.
Parent	Returns the parent object for the specified object. Read-only.
PictureType	Returns or sets a XlChartPictureType value that represents the way pictures are displayed on a legend key.
PictureUnit2	Returns or sets the unit for each picture on the chart if the PictureType property is set to xlStackScale (if not, this property is ignored). Read/write Double.
Shadow	Returns or sets a Boolean value that determines if the object has a shadow.
Smooth	True if curve smoothing is turned on for the legend key. Read/write.
Top	Returns 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 a Double value that represents the width, in points, of the object.