Excel.Interfaces.ChartSeriesData interface
An interface describing the data returned by calling chartSeries.toJSON().
Properties
| chart |
Represents the chart type of a series. See |
| doughnut |
Represents the doughnut hole size of a chart series. Only valid on doughnut and doughnut exploded charts. Throws an |
| filtered | Specifies if the series is filtered. Not applicable for surface charts. |
| format | Represents the formatting of a chart series, which includes fill and line formatting. |
| gap |
Represents the gap width of a chart series. Only valid on bar and column charts, as well as specific classes of line and pie charts. Throws an invalid argument exception on invalid charts. |
| has |
Specifies if the series has data labels. |
| marker |
Specifies the marker background color of a chart series. |
| marker |
Specifies the marker foreground color of a chart series. |
| marker |
Specifies the marker size of a chart series. 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 |
Specifies the marker style of a chart series. See |
| name | Specifies the name of a series in a chart. The name's length should not be greater than 255 characters. |
| plot |
Specifies the plot order of a chart series within the chart group. |
| points | Returns a collection of all points in the series. |
| show |
Specifies if the series has a shadow. |
| smooth | Specifies if the series is smooth. Only applicable to line and scatter charts. |
| trendlines | The collection of trendlines in the series. |
Property Details
chartType
Represents the chart type of a series. See Excel.ChartType for details.
chartType?: Excel.ChartType | "Invalid" | "ColumnClustered" | "ColumnStacked" | "ColumnStacked100" | "3DColumnClustered" | "3DColumnStacked" | "3DColumnStacked100" | "BarClustered" | "BarStacked" | "BarStacked100" | "3DBarClustered" | "3DBarStacked" | "3DBarStacked100" | "LineStacked" | "LineStacked100" | "LineMarkers" | "LineMarkersStacked" | "LineMarkersStacked100" | "PieOfPie" | "PieExploded" | "3DPieExploded" | "BarOfPie" | "XYScatterSmooth" | "XYScatterSmoothNoMarkers" | "XYScatterLines" | "XYScatterLinesNoMarkers" | "AreaStacked" | "AreaStacked100" | "3DAreaStacked" | "3DAreaStacked100" | "DoughnutExploded" | "RadarMarkers" | "RadarFilled" | "Surface" | "SurfaceWireframe" | "SurfaceTopView" | "SurfaceTopViewWireframe" | "Bubble" | "Bubble3DEffect" | "StockHLC" | "StockOHLC" | "StockVHLC" | "StockVOHLC" | "CylinderColClustered" | "CylinderColStacked" | "CylinderColStacked100" | "CylinderBarClustered" | "CylinderBarStacked" | "CylinderBarStacked100" | "CylinderCol" | "ConeColClustered" | "ConeColStacked" | "ConeColStacked100" | "ConeBarClustered" | "ConeBarStacked" | "ConeBarStacked100" | "ConeCol" | "PyramidColClustered" | "PyramidColStacked" | "PyramidColStacked100" | "PyramidBarClustered" | "PyramidBarStacked" | "PyramidBarStacked100" | "PyramidCol" | "3DColumn" | "Line" | "3DLine" | "3DPie" | "Pie" | "XYScatter" | "3DArea" | "Area" | "Doughnut" | "Radar" | "Histogram" | "Boxwhisker" | "Pareto" | "RegionMap" | "Treemap" | "Waterfall" | "Sunburst" | "Funnel";Property Value
Excel.ChartType | "Invalid" | "ColumnClustered" | "ColumnStacked" | "ColumnStacked100" | "3DColumnClustered" | "3DColumnStacked" | "3DColumnStacked100" | "BarClustered" | "BarStacked" | "BarStacked100" | "3DBarClustered" | "3DBarStacked" | "3DBarStacked100" | "LineStacked" | "LineStacked100" | "LineMarkers" | "LineMarkersStacked" | "LineMarkersStacked100" | "PieOfPie" | "PieExploded" | "3DPieExploded" | "BarOfPie" | "XYScatterSmooth" | "XYScatterSmoothNoMarkers" | "XYScatterLines" | "XYScatterLinesNoMarkers" | "AreaStacked" | "AreaStacked100" | "3DAreaStacked" | "3DAreaStacked100" | "DoughnutExploded" | "RadarMarkers" | "RadarFilled" | "Surface" | "SurfaceWireframe" | "SurfaceTopView" | "SurfaceTopViewWireframe" | "Bubble" | "Bubble3DEffect" | "StockHLC" | "StockOHLC" | "StockVHLC" | "StockVOHLC" | "CylinderColClustered" | "CylinderColStacked" | "CylinderColStacked100" | "CylinderBarClustered" | "CylinderBarStacked" | "CylinderBarStacked100" | "CylinderCol" | "ConeColClustered" | "ConeColStacked" | "ConeColStacked100" | "ConeBarClustered" | "ConeBarStacked" | "ConeBarStacked100" | "ConeCol" | "PyramidColClustered" | "PyramidColStacked" | "PyramidColStacked100" | "PyramidBarClustered" | "PyramidBarStacked" | "PyramidBarStacked100" | "PyramidCol" | "3DColumn" | "Line" | "3DLine" | "3DPie" | "Pie" | "XYScatter" | "3DArea" | "Area" | "Doughnut" | "Radar" | "Histogram" | "Boxwhisker" | "Pareto" | "RegionMap" | "Treemap" | "Waterfall" | "Sunburst" | "Funnel"
Remarks
doughnutHoleSize
Represents the doughnut hole size of a chart series. Only valid on doughnut and doughnut exploded charts. Throws an InvalidArgument error on invalid charts.
doughnutHoleSize?: number;Property Value
number
Remarks
filtered
Specifies if the series is filtered. Not applicable for surface charts.
filtered?: boolean;Property Value
boolean
Remarks
format
Represents the formatting of a chart series, which includes fill and line formatting.
format?: Excel.Interfaces.ChartSeriesFormatData;Property Value
Remarks
gapWidth
Represents the gap width of a chart series. Only valid on bar and column charts, as well as specific classes of line and pie charts. Throws an invalid argument exception on invalid charts.
gapWidth?: number;Property Value
number
Remarks
hasDataLabels
Specifies if the series has data labels.
hasDataLabels?: boolean;Property Value
boolean
Remarks
markerBackgroundColor
Specifies the marker background color of a chart series.
markerBackgroundColor?: string;Property Value
string
Remarks
markerForegroundColor
Specifies the marker foreground color of a chart series.
markerForegroundColor?: string;Property Value
string
Remarks
markerSize
Specifies the marker size of a chart series. 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
markerStyle
Specifies the marker style of a chart series. 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
name
Specifies the name of a series in a chart. The name's length should not be greater than 255 characters.
name?: string;Property Value
string
Remarks
plotOrder
Specifies the plot order of a chart series within the chart group.
plotOrder?: number;Property Value
number
Remarks
points
Returns a collection of all points in the series.
points?: Excel.Interfaces.ChartPointData[];Property Value
Remarks
showShadow
Specifies if the series has a shadow.
showShadow?: boolean;Property Value
boolean
Remarks
smooth
Specifies if the series is smooth. Only applicable to line and scatter charts.
smooth?: boolean;Property Value
boolean
Remarks
trendlines
The collection of trendlines in the series.
trendlines?: Excel.Interfaces.ChartTrendlineData[];Property Value
Remarks
Office Add-ins
Feedback
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: https://aka.ms/ContentUserFeedback.
Submit and view feedback for