Edit

Excel.Interfaces.ChartPointLoadOptions interface

  • Reference
Package:
excel

Represents a point of a series in a chart.

Remarks

[ API set: ExcelApi 1.1 ]

Properties

$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).
dataLabel

Returns the data label of a chart point.
format

Encapsulates the format properties chart point.
hasDataLabel

Represents whether a data point has a data label. Not applicable for surface charts.
markerBackgroundColor

HTML color code representation of the marker background color of a data point (e.g., #FF0000 represents Red).
markerForegroundColor

HTML color code representation of the marker foreground color of a data point (e.g., #FF0000 represents Red).
markerSize

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.
markerStyle

Represents marker style of a chart data point. See Excel.ChartMarkerStyle for details.
value

Returns the value of a chart point.

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

dataLabel

Returns the data label of a chart point.

dataLabel?: Excel.Interfaces.ChartDataLabelLoadOptions;

Property Value

Excel.Interfaces.ChartDataLabelLoadOptions

Remarks

[ API set: ExcelApi 1.7 ]

format

Encapsulates the format properties chart point.

format?: Excel.Interfaces.ChartPointFormatLoadOptions;

Property Value

Excel.Interfaces.ChartPointFormatLoadOptions

Remarks

[ API set: ExcelApi 1.1 ]

hasDataLabel

Represents whether a data point has a data label. Not applicable for surface charts.

hasDataLabel?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

markerBackgroundColor

HTML color code representation of the marker background color of a data point (e.g., #FF0000 represents Red).

markerBackgroundColor?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

markerForegroundColor

HTML color code representation of the marker foreground color of a data point (e.g., #FF0000 represents Red).

markerForegroundColor?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

markerSize

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

[ API set: ExcelApi 1.7 ]

markerStyle

Represents marker style of a chart data point. See Excel.ChartMarkerStyle for details.

markerStyle?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

value

Returns the value of a chart point.

value?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]