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