Excel.Interfaces.ChartPointLoadOptions interface
Represents a point of a series in a chart.
Remarks
Properties
$all | Specifying |
data |
Returns the data label of a chart point. |
format | Encapsulates the format properties chart point. |
has |
Represents whether a data point has a data label. Not applicable for surface charts. |
marker |
HTML color code representation of the marker background color of a data point (e.g., #FF0000 represents Red). |
marker |
HTML color code representation of the marker foreground color of a data point (e.g., #FF0000 represents Red). |
marker |
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 |
Represents marker style of a chart data point. See |
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
Remarks
format
Encapsulates the format properties chart point.
format?: Excel.Interfaces.ChartPointFormatLoadOptions;
Property Value
Remarks
hasDataLabel
Represents whether a data point has a data label. Not applicable for surface charts.
hasDataLabel?: boolean;
Property Value
boolean
Remarks
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
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
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
markerStyle
Represents marker style of a chart data point. See Excel.ChartMarkerStyle
for details.
markerStyle?: boolean;
Property Value
boolean
Remarks
value
Returns the value of a chart point.
value?: boolean;
Property Value
boolean
Remarks
Office Add-ins
Feedback
https://aka.ms/ContentUserFeedback.
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:Submit and view feedback for