Legend Object Members

Article
06/14/2014

Excel Developer Reference

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.
	AutoScaleFont	True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant.
	Format	Read-only
	Height	Returns or sets a Double value that represents the height, in points, of the object.
	IncludeInLayout	Read/write
	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.