Chart Members
In This Article
#Properties
Name | Description |
---|---|
Alternative |
Gets or sets the descriptive (alternative) text for a drawing object. Inherited from Shape. |
Bottom |
Gets or sets a cell where the bottom right corner of a floating object is located.
Inherited from Floating |
Chart |
Returns the chart type.
Inherited from Chart |
Color |
Returns or specifies a color palette for the chart. Applies only to Excel 2016 charts.
Inherited from Chart |
Connector |
Provides access to the shape connector settings. Inherited from Shape. |
Data |
Provides access to display settings for the chart data table.
Inherited from Chart |
Decorative | Gets or sets whether the shape is marked as decorative. Inherited from Shape. |
Fill |
Provides access to fill options for the specified drawing object.
Inherited from Shape |
Font |
Allows you to change the text font for all chart elements.
Inherited from Chart |
Height |
Gets or sets the height of the floating object.
Inherited from Floating |
Hyperlink | Gets the hyperlink associated with a drawing object (picture). Inherited from Shape. |
Id | Gets the drawing object identifier. Inherited from Shape. |
Left |
Gets or sets the distance from the left edge of the worksheet to the top left corner of the floating object.
Inherited from Floating |
Legend |
Provides access to a chart legend.
Inherited from Chart |
Lock |
Gets or sets whether the floating object retains its original proportions after resizing.
Inherited from Floating |
Name | Gets or sets the name of the drawing object. Inherited from Shape. |
Offset |
Gets a distance from the top left corner of the floating to the left edge of the cell where the top left corner of the floating object is located.
Inherited from Floating |
Offset |
Gets a distance from the top left corner of the floating object to the top edge of the cell where the top left corner of the floating object is located.
Inherited from Floating |
Options |
Provides access to various options available for the chart.
Inherited from Chart |
Outline |
Provides access to the options used to format an outline of the specified drawing object.
Inherited from Shape |
Parent |
Retrieves the group in which the current shape is contained. Inherited from Shape. |
Placement |
Gets or sets the behavior of the floating object regarding the cells below.
Inherited from Floating |
Plot |
Provides access to the chart’s plot area.
Inherited from Chart |
Primary |
Provides access to a collection of primary axes.
Inherited from Chart |
Rotation | Gets or sets the rotation of the drawing object, in degrees. Inherited from Shape. |
Secondary |
Provides access to a collection of secondary axes.
Inherited from Chart |
Series |
Provides access to the collection of Series objects.
Inherited from Chart |
Shape |
Provides access to the shape’s geometry options. Inherited from Shape. |
Shape |
Provides access to the shape’s text options. Inherited from Shape. |
Shape |
Returns the type of the drawing object. Inherited from Shape. |
Style |
Returns or specifies the chart style.
Inherited from Chart |
Title |
Gets the title of the chart.
Inherited from Chart |
Top |
Gets or sets the distance from the top edge of the worksheet to the top left corner of the floating object.
Inherited from Floating |
Top |
Gets or sets a cell where the top left corner of a floating object is located.
Inherited from Floating |
View3D |
Provides access to the display settings of three-dimensional charts.
Inherited from Chart |
Views |
Returns a collection of chart views.
Inherited from Chart |
Width |
Gets or sets the width of the floating object.
Inherited from Floating |
ZOrder |
Gets the position of the current drawing object in the z-order. Inherited from Shape. |
#Methods
Name | Description |
---|---|
Change |
Changes the type of the chart.
Inherited from Chart |
Copy |
Creates a copy of the chart in another worksheet.
Inherited from Chart |
Delete() | Deletes a drawing object. Inherited from Shape. |
Export |
Saves the drawing object as an image. Inherited from Shape. |
Export |
Saves the drawing object as an image in the specified format. Inherited from Shape. |
Export |
Saves the drawing object as an image in the specified format. Inherited from Shape. |
Get |
Retrieves the list of nested shapes and shape groups. Inherited from Shape. |
Get |
Returns a cell range containing chart data.
Inherited from Chart |
Get |
Converts the chart to an image.
Inherited from Chart |
Get |
Converts the chart to an image of the specified size.
Inherited from Chart |
Increment |
Increments the rotation angle of the drawing object by the specified number of degrees. Inherited from Shape. |
Insert |
Associates a hyperlink with the drawing object. Inherited from Shape. |
Load |
Loads a custom style from the specified stream and applies it to the chart. Available only for Excel 2016 charts.
Inherited from Chart |
Load |
Loads a custom style from the specified XML file and applies it to the chart. Available only for Excel 2016 charts.
Inherited from Chart |
Load |
Loads a custom chart style and formatting settings from the stream and applies it to the chart.
Inherited from Chart |
Move |
Moves a floating object by a specified offset.
Inherited from Floating |
Move |
Moves the current chart to a separate chart sheet.
Inherited from Chart |
Move |
Moves a chart to the specified worksheet.
Inherited from Chart |
Remove |
Removes the hyperlink associated with the current drawing object. Inherited from Shape. |
Reset |
Removes custom formatting of the chart element and applies default formatting based on the chart style.
Inherited from Shape |
Select |
Specifies the source data for the chart.
Inherited from Chart |
Select |
Specifies the source data for the chart.
Inherited from Chart |
Switch |
Switches rows to columns in the chart data, plotting them on different axes.
Inherited from Chart |
See Also