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