.
Description
The Chart class represents an Excel chart. It is the main class for code-based chart creation and modification.
C#
vb.net
Remarks
To create aChart object:
Properties
Name |
Description |
|---|---|
| Returns a CategoryAxis object representing the chart's X axis. | |
| Returns a ChartRegion object, representing the chart area in the worksheet. The chart area is the entire area within the worksheet assigned to the chart. | |
| Returns a ChartSettings3D object representing the properties of a three-dimensional chart. | |
| Sets or returns the chart's type (Area, Column, Bubble, etc.). | |
| For all chart types except Pie, Doughnut, Bubble, and Surface, DataTable returns a ChartDataTable object, representing a chart's data table. | |
| Sets or returns the height of the chart, in points (1/72 inch). | |
| Returns a Legend object, representing the chart's legend. | |
| Sets or returns the name of the chart. | |
| Sets or returns the ObjectPositioning value that determines the chart's resize and reposition behavior when the cells in the worksheet are changed. | |
| Returns the ChartPageSetup object for this chart. | |
| Returns a ChartRegion object, representing the chart's plot area, the area of the chart itself. | |
| Sets or returns the chart's position in the worksheet. | |
| Returns the 0-based position in the parent Charts collection. If this Chart is on its own Chartsheet, then this will return 0. | |
| Returns a ValueAxis object representing the chart's scatter values on the X axis. | |
| Returns a CategoryAxis object, representing a chart's secondary X axis. | |
| Returns a ValueAxis object, representing a chart's secondary Y axis. | |
| Returns a SeriesCollection object representing the set of data series in the chart. | |
| Sets or returns whether the chart area will be sharp-cornered or round-cornered. | |
| Returns a ChartText object representing the chart's title. | |
| Returns a ValueAxis object, representing a chart's Y axis. | |
| Sets or returns the width of the chart, in points (1/72 inch). | |
| Returns a CategoryAxis object representing the chart's category values on the Z axis. |
Methods
Name |
Description |
|---|---|
| Moves the chart to a different worksheet. The method specifies whether the chart should be inserted as an object within the worksheet, or converted to a chart sheet. | |
| Moves the chart to a different worksheet. The method specifies whether the chart should be inserted as an object within the worksheet, or converted to a chart sheet. | |
| Moves the chart to a different worksheet. The method specifies whether the chart should be inserted as an object within the worksheet, or converted to a chart sheet. | |
| Moves the chart to a different worksheet. The method specifies whether the chart should be inserted as an object within the worksheet, or converted to a chart sheet. |
Nested Classes
Name |
Description |
|---|---|
| A ChartLocation value specifies whether a chart should be an object within a worksheet, or converted to a chart sheet. |