Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ChartArea Object Members

Office 2007

Represents the chart area of a chart.

Methods

 NameDescription
Bb255886.methods(en-us,office.12).gif Clear Clears the entire object.
Bb255886.methods(en-us,office.12).gif ClearContents Clears the data from a chart but leaves the formatting.
Bb255886.methods(en-us,office.12).gif ClearFormats Clears the formatting of the object.
Bb255886.methods(en-us,office.12).gif Copy Copies the object to the Clipboard.
Bb255886.methods(en-us,office.12).gif Select Selects the object.

Properties

 NameDescription
Bb255886.properties(en-us,office.12).gif 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.
Bb255886.properties(en-us,office.12).gif AutoScaleFont True if the text in the object changes font size when the object size changes. The default value is True. Read/write Variant.
Bb255886.properties(en-us,office.12).gif Format Read-only
Bb255886.properties(en-us,office.12).gif Height Returns or sets a Double value that represents the height, in points, of the object.
Bb255886.properties(en-us,office.12).gif 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).
Bb255886.properties(en-us,office.12).gif Name Returns a String value that represents the name of the object.
Bb255886.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255886.properties(en-us,office.12).gif Shadow Returns or sets a Boolean value that determines if the object has a shadow.
Bb255886.properties(en-us,office.12).gif 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).
Bb255886.properties(en-us,office.12).gif Width Returns or sets a Double value that represents the width, in points, of the object.


Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.