.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

Chart Members

An embedded chart on a worksheet.

Properties

Name Description
AlternativeText Gets or sets the descriptive (alternative) text for a drawing object. Inherited from Shape.
BottomRightCell Gets or sets a cell where the bottom right corner of a floating object is located. Inherited from FloatingObject.
ChartType Returns the chart type. Inherited from ChartObject.
ColorPalette Returns or specifies a color palette for the chart. Applies only to Excel 2016 charts. Inherited from ChartObject.
ConnectorFormat Provides access to the shape connector settings. Inherited from Shape.
DataTable Provides access to display settings for the chart data table. Inherited from ChartObject.
Fill Provides access to fill options for the specified drawing object. Inherited from ShapeFormatBase.
Font Allows you to change the text font for all chart elements. Inherited from ChartObject.
Height Gets or sets the height of the floating object. Inherited from FloatingObject.
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 FloatingObject.
Legend Provides access to a chart legend. Inherited from ChartObject.
LockAspectRatio Gets or sets whether the floating object retains its original proportions after resizing. Inherited from FloatingObject.
Name Gets or sets the name of the drawing object. Inherited from Shape.
OffsetX 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 FloatingObject.
OffsetY 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 FloatingObject.
Options Provides access to various options available for the chart. Inherited from ChartObject.
Outline Provides access to the options used to format an outline of the specified drawing object. Inherited from ShapeFormatBase.
ParentGroup 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 FloatingObject.
PlotArea Provides access to the chart’s plot area. Inherited from ChartObject.
PrimaryAxes Provides access to a collection of primary axes. Inherited from ChartObject.
Rotation Gets or sets the rotation of the drawing object, in degrees. Inherited from Shape.
SecondaryAxes Provides access to a collection of secondary axes. Inherited from ChartObject.
Series Provides access to the collection of Series objects. Inherited from ChartObject.
ShapeGeometry Provides access to the shape’s geometry options. Inherited from Shape.
ShapeText Provides access to the shape’s text options. Inherited from Shape.
ShapeType Returns the type of the drawing object. Inherited from Shape.
Style Returns or specifies the chart style. Inherited from ChartObject.
Title Gets the title of the chart. Inherited from ChartObject.
Top Gets or sets the distance from the top edge of the worksheet to the top left corner of the floating object. Inherited from FloatingObject.
TopLeftCell Gets or sets a cell where the top left corner of a floating object is located. Inherited from FloatingObject.
View3D Provides access to the display settings of three-dimensional charts. Inherited from ChartObject.
Views Returns a collection of chart views. Inherited from ChartObject.
Width Gets or sets the width of the floating object. Inherited from FloatingObject.
ZOrderPosition Gets the position of the current drawing object in the z-order. Inherited from Shape.

Methods

Name Description
ChangeType(ChartType) Changes the type of the chart. Inherited from ChartObject.
CopyTo(Worksheet) Creates a copy of the chart in another worksheet. Inherited from ChartObject.
Delete() Deletes a drawing object. Inherited from Shape.
ExportToImage() Saves the drawing object as an image. Inherited from Shape.
ExportToImage(Stream, ImageFileFormat) Saves the drawing object as an image in the specified format. Inherited from Shape.
ExportToImage(String, ImageFileFormat) Saves the drawing object as an image in the specified format. Inherited from Shape.
GetChildren() Retrieves the list of nested shapes and shape groups. Inherited from Shape.
GetDataRange() Returns a cell range containing chart data. Inherited from ChartObject.
GetImage() Converts the chart to an image. Inherited from ChartObject.
GetImage(Size) Converts the chart to an image of the specified size. Inherited from ChartObject.
IncrementRotation(Int32) Increments the rotation angle of the drawing object by the specified number of degrees. Inherited from Shape.
InsertHyperlink(String, Boolean) Associates a hyperlink with the drawing object. Inherited from Shape.
LoadStyle(Stream) Loads a custom style from the specified stream and applies it to the chart. Available only for Excel 2016 charts. Inherited from ChartObject.
LoadStyle(String) Loads a custom style from the specified XML file and applies it to the chart. Available only for Excel 2016 charts. Inherited from ChartObject.
Move(Single, Single) Moves a floating object by a specified offset. Inherited from FloatingObject.
MoveToNewChartSheet(String) Moves the current chart to a separate chart sheet. Inherited from ChartObject.
MoveToWorksheet(Worksheet) Moves a chart to the specified worksheet. Inherited from ChartObject.
RemoveHyperlink() Removes the hyperlink associated with the current drawing object. Inherited from Shape.
ResetToMatchStyle() Removes custom formatting of the chart element and applies default formatting based on the chart style. Inherited from ShapeFormat.
SelectData(CellRange) Specifies the source data for the chart. Inherited from ChartObject.
SelectData(CellRange, ChartDataDirection) Specifies the source data for the chart. Inherited from ChartObject.
SwitchRowColumn() Switches rows to columns in the chart data, plotting them on different axes. Inherited from ChartObject.
See Also