Message-ID: <735883592.7765.1711620557058.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7764_163337894.1711620557058" ------=_Part_7764_163337894.1711620557058 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Chart

Chart

Description

=20

The Chart class represents an Excel = chart. It is the main class for code-based chart creation and modification.=

=20
C#
=20
 public sealed class Chart
=20
=20
vb.net
=20
Public NotInheritable Class Chart
=20
=20

Remarks

To create a=20 Chart object:=20

Properties

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

= CategoryAxis

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

Cha= rtArea

Returns a = ChartRegion object, representing the chart area in the worksheet. The c= hart area is the entire area within the worksheet assigned to the chart.=20

ChartSettings3D

Returns a ChartSettings3D object representing the properties of a three-dimen= sional chart.

Cha= rtType

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

Dat= aTable

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

Height=

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

Legend=

Returns a Legen= d 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 chang= ed.

Pag= eSetup

Returns the ChartPageSetup object for this chart.

Plot= Area

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

Posi= tion

Sets or returns the chart's position in the work= sheet.

PositionInCollection

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

ScatterValueAxis

Returns a Va= lueAxis object representing the chart's scatter values on the X axis.=20

SecondaryCategoryAxis

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

SecondaryValueAxis

Returns a Va= lueAxis 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 s= harp-cornered or round-cornered.

Title

Returns a Ch= artText object representing the chart's title.

Val= ueAxis

Returns a Va= lueAxis object, representing a chart's Y axis.

Width

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

ZCategoryAxis

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

Methods

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

MoveChart(Chart.ChartLocation, Int32)

Moves the chart to a different worksheet. The me= thod 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 me= thod 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 me= thod 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 me= thod specifies whether the chart should be inserted as an object within the= worksheet, or converted to a chart sheet.
=20

Nested Classes

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20

Name

Description

ChartLocation

A = ChartLocation value specifies whether a chart should be an object withi= n a worksheet, or converted to a chart sheet.
------=_Part_7764_163337894.1711620557058--