ChartObject Members
Contains basic properties and methods for embedded charts and chart sheets.Properties
Name | Description |
---|---|
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 | Gets or sets the style to be applied to the chart. |
Title | Gets the title of the chart. |
View3D | Provides access to the display settings of three-dimensional charts. |
Views | Provides access to 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. |
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 the source data for the chart. |
SelectData(Range) | Specifies the source data for the chart. |
SwitchRowColumn() | Switches rows to columns in the chart data, plotting them on different axes. |
See Also