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

Description

The Charts collection contains all charts in the specified worksheet. Chart sheets are not included in this collection. To return a Charts collection, use Worksheet.Charts.

C#
vb.net

Properties

Name

Description

Count

Returns the number of charts in the worksheet.

Indexers

Name

Description

Item(Int32)

Returns the chart at the specified 0-based position in the Charts collection.

Item(String)

Returns the chart with the specified name in the Charts collection.

Methods

Name

Description

AddChart(Chart, Anchor)

Creates a copy of the specified chart and adds it to the current worksheet. This method allows you to add a chart from an external workbook to the worksheet, or to duplicate a chart within a single workbook. The properties and settings on the original chart will be preserved

CreateChart(ChartType, Anchor)

Creates a new, blank chart of the specified type.

GetEnumerator()

Returns an IEnumerator for the Charts in a Worksheet

Remove(Chart)

Permanently removes the specified chart from the worksheet.

Remove(Int32)

Permanently removes the chart at the specified position from the worksheet.
  • No labels