Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Description

Excerpt

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

Signature
C#
C#
 public sealed class Chart
{signature}{signature:
}
Signature
vb.net
vb.net
Public NotInheritable Class Chart
{signature}
{remarks}To create a {{Chart}} object:

{remarks}
{properties}
||Name||Description||
|[CategoryAxis|Chart.CategoryAxis]|{excerpt-include:Chart.CategoryAxis|nopanel=true}|
|[ChartArea|Chart.ChartArea]|{excerpt-include:Chart.ChartArea|nopanel=true}|
|[ChartSettings3D|Chart.ChartSettings3D]|{excerpt-include:Chart.ChartSettings3D|nopanel=true}|
|[ChartType|Chart.ChartType]|{excerpt-include:Chart.ChartType|nopanel=true}|
|[DataTable|Chart.DataTable]|{excerpt-include:Chart.DataTable|nopanel=true}|
|[Height|Chart.Height]|{excerpt-include:Chart.Height|nopanel=true}|
|[Legend|Chart.Legend]|{excerpt-include:Chart.Legend|nopanel=true}|
|[Name|Chart.Name]|{excerpt-include:Chart.Name|nopanel=true}|
|[ObjectPositioning|Chart.ObjectPositioning]|{excerpt-include:Chart.ObjectPositioning|nopanel=true}|
|[PageSetup|Chart.PageSetup]|{excerpt-include:Chart.PageSetup|nopanel=true}|
|[PlotArea|Chart.PlotArea]|{excerpt-include:Chart.PlotArea|nopanel=true}|
|[Position|Chart.Position]|{excerpt-include:Chart.Position|nopanel=true}|
|[PositionInCollection|Chart.PositionInCollection]|{excerpt-include:Chart.PositionInCollection|nopanel=true}|
|[ScatterValueAxis|Chart.ScatterValueAxis]|{excerpt-include:Chart.ScatterValueAxis|nopanel=true}|
|[SecondaryCategoryAxis|Chart.SecondaryCategoryAxis]|{excerpt-include:Chart.SecondaryCategoryAxis|nopanel=true}|
|[SecondaryValueAxis|Chart.SecondaryValueAxis]|{excerpt-include:Chart.SecondaryValueAxis|nopanel=true}|
|[SeriesCollection|Chart.SeriesCollection]|{excerpt-include:Chart.SeriesCollection|nopanel=true}|
|[ShowRoundedCorners|Chart.ShowRoundedCorners]|{excerpt-include:Chart.ShowRoundedCorners|nopanel=true}|
|[Title|Chart.Title]|{excerpt-include:Chart.Title|nopanel=true}|
|[ValueAxis|Chart.ValueAxis]|{excerpt-include:Chart.ValueAxis|nopanel=true}|
|[Width|Chart.Width]|{excerpt-include:Chart.Width|nopanel=true}|
|[ZCategoryAxis|Chart.ZCategoryAxis]|{excerpt-include:Chart.ZCategoryAxis|nopanel=true}|
{methods}
||Name||Description||
|[MoveChart(Chart.ChartLocation, Int32)|
Remarks

To create a Chart object:

Properties

Name

Description

CategoryAxis

Excerpt Include
Chart.CategoryAxis
Chart.CategoryAxis
nopaneltrue

ChartArea

Excerpt Include
Chart.ChartArea
Chart.ChartArea
nopaneltrue

ChartSettings3D

Excerpt Include
Chart.ChartSettings3D
Chart.ChartSettings3D
nopaneltrue

ChartType

Excerpt Include
Chart.ChartType
Chart.ChartType
nopaneltrue

DataTable

Excerpt Include
Chart.DataTable
Chart.DataTable
nopaneltrue

Height

Excerpt Include
Chart.Height
Chart.Height
nopaneltrue

Legend

Excerpt Include
Chart.Legend
Chart.Legend
nopaneltrue

Name

Excerpt Include
Chart.Name
Chart.Name
nopaneltrue

ObjectPositioning

Excerpt Include
Chart.ObjectPositioning
Chart.ObjectPositioning
nopaneltrue

PageSetup

Excerpt Include
Chart.PageSetup
Chart.PageSetup
nopaneltrue

PlotArea

Excerpt Include
Chart.PlotArea
Chart.PlotArea
nopaneltrue

Position

Excerpt Include
Chart.Position
Chart.Position
nopaneltrue

PositionInCollection

Excerpt Include
Chart.PositionInCollection
Chart.PositionInCollection
nopaneltrue

ScatterValueAxis

Excerpt Include
Chart.ScatterValueAxis
Chart.ScatterValueAxis
nopaneltrue

SecondaryCategoryAxis

Excerpt Include
Chart.SecondaryCategoryAxis
Chart.SecondaryCategoryAxis
nopaneltrue

SecondaryValueAxis

Excerpt Include
Chart.SecondaryValueAxis
Chart.SecondaryValueAxis
nopaneltrue

SeriesCollection

Excerpt Include
Chart.SeriesCollection
Chart.SeriesCollection
nopaneltrue

ShowRoundedCorners

Excerpt Include
Chart.ShowRoundedCorners
Chart.ShowRoundedCorners
nopaneltrue

Title

Excerpt Include
Chart.Title
Chart.Title
nopaneltrue

ValueAxis

Excerpt Include
Chart.ValueAxis
Chart.ValueAxis
nopaneltrue

Width

Excerpt Include
Chart.Width
Chart.Width
nopaneltrue

ZCategoryAxis

Excerpt Include
Chart.ZCategoryAxis
Chart.ZCategoryAxis
nopaneltrue
Methods

Name

Description

MoveChart(Chart.ChartLocation, Int32)

Excerpt Include
Chart.MoveChart(Chart.ChartLocation,

...

Int32)

...

Chart.MoveChart(Chart.ChartLocation,

...

Int32)

...

nopanel

...

...

...

...

Excerpt Include
Chart.MoveChart(Chart.ChartLocation,

...

Int32,

...

Anchor)

...

Chart.MoveChart(Chart.ChartLocation,

...

Int32,

...

Anchor)

...

nopanel

...

...

...

Excerpt Include
Chart.MoveChart(Chart.ChartLocation,

...

String)

...

Chart.MoveChart(Chart.ChartLocation,

...

String)

...

nopanel

...

...

...

...

Excerpt Include
Chart.MoveChart(Chart.ChartLocation,

...

String,

...

Int32)

...

Chart.MoveChart(Chart.ChartLocation,

...

String,

...

Int32)

...

nopanel

...

true
Classes

Name

Description

ChartLocation

Excerpt Include
Chart.ChartLocation
Chart.ChartLocation
nopaneltrue
Scrollbar