Skip to main content
A newer version of this page is available. .

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.
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(Range, ChartDataDirection) Specifies a worksheet range containing chart data and creates series with automatically selected type.
SelectData(Range) Specifies a worksheet range containing chart data and creates series with automatically selected type.
SwitchRowColumn() Switches rows to columns in the chart data, plotting them on different axes.
See Also