Page tree
Skip to end of metadata
Go to start of metadata

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 a Chart object:

Properties

Name

Description

CategoryAxis

Returns a CategoryAxis object representing the chart's X axis.

ChartArea

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.

ChartSettings3D

Returns a ChartSettings3D object representing the properties of a three-dimensional chart.

ChartType

Sets or returns the chart's type (Area, Column, Bubble, etc.).

DataTable

For all chart types except Pie, Doughnut, Bubble, and Surface, DataTable returns a ChartDataTable object, representing a chart's data table.

Height

Sets or returns the height of the chart, in points (1/72 inch).

Legend

Returns a Legend object, representing the chart's legend.

Name

Sets or returns the name of the chart.

ObjectPositioning

Sets or returns the ObjectPositioning value that determines the chart's resize and reposition behavior when the cells in the worksheet are changed.

PageSetup

Returns the ChartPageSetup object for this chart.

PlotArea

Returns a ChartRegion object, representing the chart's plot area, the area of the chart itself.

Position

Sets or returns the chart's position in the worksheet.

PositionInCollection

Returns the 0-based position in the parent Charts collection. If this Chart is on its own Chartsheet, then this will return 0.

ScatterValueAxis

Returns a ValueAxis object representing the chart's scatter values on the X axis.

SecondaryCategoryAxis

Returns a CategoryAxis object, representing a chart's secondary X axis.

SecondaryValueAxis

Returns a ValueAxis object, representing a chart's secondary Y axis.

SeriesCollection

Returns a SeriesCollection object representing the set of data series in the chart.

ShowRoundedCorners

Sets or returns whether the chart area will be sharp-cornered or round-cornered.

Title

Returns a ChartText object representing the chart's title.

ValueAxis

Returns a ValueAxis object, representing a chart's Y axis.

Width

Sets or returns the width of the chart, in points (1/72 inch).

ZCategoryAxis

Returns a CategoryAxis object representing the chart's category values on the Z axis.

Methods

Name

Description

MoveChart(Chart.ChartLocation, Int32)

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.

MoveChart(Chart.ChartLocation, Int32, Anchor)

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.

MoveChart(Chart.ChartLocation, String)

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.

MoveChart(Chart.ChartLocation, String, Int32)

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

ChartLocation

A ChartLocation value specifies whether a chart should be an object within a worksheet, or converted to a chart sheet.
  • No labels