Excel.Interfaces.ChartPointsCollectionLoadOptions interface
A collection of all the chart points within a series inside a chart.
Remarks
Properties
$all | Specifying |
data |
For EACH ITEM in the collection: Returns the data label of a chart point. |
format | For EACH ITEM in the collection: Encapsulates the format properties chart point. |
has |
For EACH ITEM in the collection: Represents whether a data point has a data label. Not applicable for surface charts. |
marker |
For EACH ITEM in the collection: HTML color code representation of the marker background color of a data point (e.g., #FF0000 represents Red). |
marker |
For EACH ITEM in the collection: HTML color code representation of the marker foreground color of a data point (e.g., #FF0000 represents Red). |
marker |
For EACH ITEM in the collection: Represents marker size of a data point. The supported size range is 2 to 72. This method returns an InvalidArgument error if it's set with a size outside of the supported range. |
marker |
For EACH ITEM in the collection: Represents marker style of a chart data point. See |
value | For EACH ITEM in the collection: Returns the value of a chart point. |
Property Details
$all
Specifying $all
for the load options loads all the scalar properties (such as Range.address
) but not the navigational properties (such as Range.format.fill.color
).
$all?: boolean;
Property Value
boolean
dataLabel
For EACH ITEM in the collection: Returns the data label of a chart point.
dataLabel?: Excel.Interfaces.ChartDataLabelLoadOptions;
Property Value
Remarks
format
For EACH ITEM in the collection: Encapsulates the format properties chart point.
format?: Excel.Interfaces.ChartPointFormatLoadOptions;
Property Value
Remarks
hasDataLabel
For EACH ITEM in the collection: Represents whether a data point has a data label. Not applicable for surface charts.
hasDataLabel?: boolean;
Property Value
boolean
Remarks
markerBackgroundColor
For EACH ITEM in the collection: HTML color code representation of the marker background color of a data point (e.g., #FF0000 represents Red).
markerBackgroundColor?: boolean;
Property Value
boolean
Remarks
markerForegroundColor
For EACH ITEM in the collection: HTML color code representation of the marker foreground color of a data point (e.g., #FF0000 represents Red).
markerForegroundColor?: boolean;
Property Value
boolean
Remarks
markerSize
For EACH ITEM in the collection: Represents marker size of a data point. The supported size range is 2 to 72. This method returns an InvalidArgument error if it's set with a size outside of the supported range.
markerSize?: boolean;
Property Value
boolean
Remarks
markerStyle
For EACH ITEM in the collection: Represents marker style of a chart data point. See Excel.ChartMarkerStyle
for details.
markerStyle?: boolean;
Property Value
boolean
Remarks
value
For EACH ITEM in the collection: Returns the value of a chart point.
value?: boolean;
Property Value
boolean
Remarks
Office Add-ins