Excel.Interfaces.ChartCollectionLoadOptions interface
A collection of all the chart objects on a worksheet.
Remarks
Properties
| $all | Specifying |
| axes | For EACH ITEM in the collection: Represents chart axes. |
| data |
For EACH ITEM in the collection: Represents the data labels on the chart. |
| format | For EACH ITEM in the collection: Encapsulates the format properties for the chart area. |
| height | For EACH ITEM in the collection: Specifies the height, in points, of the chart object. |
| left | For EACH ITEM in the collection: The distance, in points, from the left side of the chart to the worksheet origin. |
| legend | For EACH ITEM in the collection: Represents the legend for the chart. |
| name | For EACH ITEM in the collection: Specifies the name of a chart object. |
| series | For EACH ITEM in the collection: Represents either a single series or collection of series in the chart. |
| title | For EACH ITEM in the collection: Represents the title of the specified chart, including the text, visibility, position, and formatting of the title. |
| top | For EACH ITEM in the collection: Specifies the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart). |
| width | For EACH ITEM in the collection: Specifies the width, in points, of the chart object. |
| worksheet | For EACH ITEM in the collection: The worksheet containing the current chart. |
Property Details
$all
Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).
$all?: boolean;Property Value
boolean
axes
For EACH ITEM in the collection: Represents chart axes.
axes?: Excel.Interfaces.ChartAxesLoadOptions;Property Value
Remarks
dataLabels
For EACH ITEM in the collection: Represents the data labels on the chart.
dataLabels?: Excel.Interfaces.ChartDataLabelsLoadOptions;Property Value
Remarks
format
For EACH ITEM in the collection: Encapsulates the format properties for the chart area.
format?: Excel.Interfaces.ChartAreaFormatLoadOptions;Property Value
Remarks
height
For EACH ITEM in the collection: Specifies the height, in points, of the chart object.
height?: boolean;Property Value
boolean
Remarks
left
For EACH ITEM in the collection: The distance, in points, from the left side of the chart to the worksheet origin.
left?: boolean;Property Value
boolean
Remarks
legend
For EACH ITEM in the collection: Represents the legend for the chart.
legend?: Excel.Interfaces.ChartLegendLoadOptions;Property Value
Remarks
name
For EACH ITEM in the collection: Specifies the name of a chart object.
name?: boolean;Property Value
boolean
Remarks
series
For EACH ITEM in the collection: Represents either a single series or collection of series in the chart.
series?: Excel.Interfaces.ChartSeriesCollectionLoadOptions;Property Value
Remarks
title
For EACH ITEM in the collection: Represents the title of the specified chart, including the text, visibility, position, and formatting of the title.
title?: Excel.Interfaces.ChartTitleLoadOptions;Property Value
Remarks
top
For EACH ITEM in the collection: Specifies the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
top?: boolean;Property Value
boolean
Remarks
width
For EACH ITEM in the collection: Specifies the width, in points, of the chart object.
width?: boolean;Property Value
boolean
Remarks
worksheet
For EACH ITEM in the collection: The worksheet containing the current chart.
worksheet?: Excel.Interfaces.WorksheetLoadOptions;Property Value
Remarks
Office Add-ins
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for