Excel.Interfaces.ChartPointData interface

Package:

excel

An interface describing the data returned by calling chartPoint.toJSON().

Properties

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

dataLabel

Returns the data label of a chart point.

dataLabel?: Excel.Interfaces.ChartDataLabelData;

Property Value

Excel.Interfaces.ChartDataLabelData

Remarks

[ API set: ExcelApi 1.7 ]

format

Encapsulates the format properties chart point.

format?: Excel.Interfaces.ChartPointFormatData;

Property Value

Excel.Interfaces.ChartPointFormatData

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?: string;

Property Value

string

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?: string;

Property Value

string

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?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.7 ]

markerStyle

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

markerStyle?: Excel.ChartMarkerStyle | "Invalid" | "Automatic" | "None" | "Square" | "Diamond" | "Triangle" | "X" | "Star" | "Dot" | "Dash" | "Circle" | "Plus" | "Picture";

Property Value

Excel.ChartMarkerStyle | "Invalid" | "Automatic" | "None" | "Square" | "Diamond" | "Triangle" | "X" | "Star" | "Dot" | "Dash" | "Circle" | "Plus" | "Picture"

Remarks

[ API set: ExcelApi 1.7 ]

value

Returns the value of a chart point.

value?: any;

Property Value

any

Remarks

[ API set: ExcelApi 1.1 ]