Skip to main content

ChartObject Methods

Contains basic properties and methods for embedded charts and chart sheets.
Name Description
ChangeType(ChartType) Changes the type of the chart.
CopyTo(Worksheet) Creates a copy of the chart in another worksheet.
GetDataRange() Returns a cell range containing chart data.
GetImage() Converts the chart to an image.
GetImage(Size) Converts the chart to an image of the specified size.
LoadStyle(Stream) Loads a custom style from the specified stream and applies it to the chart. Available only for Excel 2016 charts.
LoadStyle(String) Loads a custom style from the specified XML file and applies it to the chart. Available only for Excel 2016 charts.
LoadTemplate(Stream) Loads a custom chart style and formatting settings from the stream and applies it to the chart.
MoveToNewChartSheet(String) Moves the current chart to a separate chart sheet.
MoveToWorksheet(Worksheet) Moves a chart to the specified worksheet.
ResetToMatchStyle() Removes custom formatting of the chart element and applies default formatting based on the chart style. Inherited from ShapeFormat.
SelectData(CellRange, ChartDataDirection) Specifies the source data for the chart.
SelectData(CellRange) Specifies the source data for the chart.
SwitchRowColumn() Switches rows to columns in the chart data, plotting them on different axes.
See Also