Edit

Share via

Excel.Interfaces.ChartPointUpdateData interface

  • Reference
Package:
excel

An interface for updating data on the ChartPoint object, for use in chartPoint.set({ ... }).

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.

Property Details

dataLabel

Returns the data label of a chart point.

dataLabel?: Excel.Interfaces.ChartDataLabelUpdateData;

Property Value

Excel.Interfaces.ChartDataLabelUpdateData

Remarks

[ API set: ExcelApi 1.7 ]

format

Encapsulates the format properties chart point.

format?: Excel.Interfaces.ChartPointFormatUpdateData;

Property Value

Excel.Interfaces.ChartPointFormatUpdateData

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 ]