ChartObject Members
Contains basic properties and methods for embedded charts and chart sheets.Properties
| Name | Description |
|---|---|
| ChartType | Returns the chart type. |
| ColorPalette | Returns or specifies a color palette for the chart. Applies only to Excel 2016 charts. |
| DataTable | Provides access to display settings for the chart data table. |
| 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. |
| Legend | Provides access to a chart legend. |
| Options | Provides access to various options available for the chart. |
| Outline | Provides access to the options used to format an outline of the specified drawing object. Inherited from ShapeFormatBase. |
| PlotArea | Provides access to the chart’s plot area. |
| PrimaryAxes | Provides access to a collection of primary axes. |
| SecondaryAxes | Provides access to a collection of secondary axes. |
| Series | Provides access to the collection of Series objects. |
| Style | Returns or specifies the chart style. |
| Title | Gets the title of the chart. |
| View3D | Provides access to the display settings of three-dimensional charts. |
| Views | Returns a collection of chart views. |
Methods
| 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