Excel.Interfaces.ChartData interface
An interface describing the data returned by calling chart.toJSON()
.
Properties
axes | Represents chart axes. |
chart |
Specifies the type of the chart. See |
data |
Represents the data labels on the chart. |
format | Encapsulates the format properties for the chart area. |
height | Specifies the height, in points, of the chart object. |
id | The unique ID of chart. |
left | The distance, in points, from the left side of the chart to the worksheet origin. |
legend | Represents the legend for the chart. |
name | Specifies the name of a chart object. |
series | Represents either a single series or collection of series in the chart. |
show |
Specifies whether to display all field buttons on a PivotChart. |
title | Represents the title of the specified chart, including the text, visibility, position, and formatting of the title. |
top | Specifies the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart). |
width | Specifies the width, in points, of the chart object. |
Property Details
axes
Represents chart axes.
axes?: Excel.Interfaces.ChartAxesData;
Property Value
Remarks
chartType
Specifies the type of the chart. 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
dataLabels
Represents the data labels on the chart.
dataLabels?: Excel.Interfaces.ChartDataLabelsData;
Property Value
Remarks
format
Encapsulates the format properties for the chart area.
format?: Excel.Interfaces.ChartAreaFormatData;
Property Value
Remarks
height
Specifies the height, in points, of the chart object.
height?: number;
Property Value
number
Remarks
id
left
The distance, in points, from the left side of the chart to the worksheet origin.
left?: number;
Property Value
number
Remarks
legend
Represents the legend for the chart.
legend?: Excel.Interfaces.ChartLegendData;
Property Value
Remarks
name
Specifies the name of a chart object.
name?: string;
Property Value
string
Remarks
series
Represents either a single series or collection of series in the chart.
series?: Excel.Interfaces.ChartSeriesData[];
Property Value
Remarks
showAllFieldButtons
Specifies whether to display all field buttons on a PivotChart.
showAllFieldButtons?: boolean;
Property Value
boolean
Remarks
title
Represents the title of the specified chart, including the text, visibility, position, and formatting of the title.
title?: Excel.Interfaces.ChartTitleData;
Property Value
Remarks
top
Specifies the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).
top?: number;
Property Value
number
Remarks
width
Specifies the width, in points, of the chart object.
width?: number;
Property Value
number
Remarks
Office Add-ins