Excel.Interfaces.ChartData interface

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

Properties

axes

Represents chart axes. Read-only.

[ API set: ExcelApi 1.1 ]

categoryLabelLevel

Returns or sets a ChartCategoryLabelLevel enumeration constant referring to the level of where the category labels are being sourced from. Read/Write.

[ API set: ExcelApi 1.8 ]

chartType

Represents the type of the chart. See Excel.ChartType for details.

[ API set: ExcelApi 1.7 ]

dataLabels

Represents the datalabels on the chart. Read-only.

[ API set: ExcelApi 1.1 ]

displayBlanksAs

Returns or sets the way that blank cells are plotted on a chart. Read/Write.

[ API set: ExcelApi 1.8 ]

format

Encapsulates the format properties for the chart area. Read-only.

[ API set: ExcelApi 1.1 ]

height

Represents the height, in points, of the chart object.

[ API set: ExcelApi 1.1 ]

id

The unique id of chart. Read-only.

[ API set: ExcelApi 1.7 ]

left

The distance, in points, from the left side of the chart to the worksheet origin.

[ API set: ExcelApi 1.1 ]

legend

Represents the legend for the chart. Read-only.

[ API set: ExcelApi 1.1 ]

name

Represents the name of a chart object.

[ API set: ExcelApi 1.1 ]

pivotOptions

Encapsulates the options for a pivot chart. Read-only.

[ API set: ExcelApi 1.9 ]

plotArea

Represents the plotArea for the chart.

[ API set: ExcelApi 1.8 ]

plotBy

Returns or sets the way columns or rows are used as data series on the chart. Read/Write.

[ API set: ExcelApi 1.8 ]

plotVisibleOnly

True if only visible cells are plotted. False if both visible and hidden cells are plotted. Read/Write.

[ API set: ExcelApi 1.8 ]

series

Represents either a single series or collection of series in the chart. Read-only.

[ API set: ExcelApi 1.1 ]

seriesNameLevel

Returns or sets a ChartSeriesNameLevel enumeration constant referring to the level of where the series names are being sourced from. Read/Write.

[ API set: ExcelApi 1.8 ]

showAllFieldButtons

Represents whether to display all field buttons on a PivotChart.

[ API set: ExcelApi 1.7 ]

showDataLabelsOverMaximum

Represents whether to show the data labels when the value is greater than the maximum value on the value axis. If value axis became smaller than the size of data points, you can use this property to set whether to show the data labels. This property applies to 2-D charts only.

[ API set: ExcelApi 1.8 ]

style

Returns or sets the chart style for the chart. Read/Write.

[ API set: ExcelApi 1.8 ]

title

Represents the title of the specified chart, including the text, visibility, position, and formatting of the title. Read-only.

[ API set: ExcelApi 1.1 ]

top

Represents 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).

[ API set: ExcelApi 1.1 ]

width

Represents the width, in points, of the chart object.

[ API set: ExcelApi 1.1 ]

Property Details

axes

Represents chart axes. Read-only.

[ API set: ExcelApi 1.1 ]

axes?: Excel.Interfaces.ChartAxesData;

Property Value

categoryLabelLevel

Returns or sets a ChartCategoryLabelLevel enumeration constant referring to the level of where the category labels are being sourced from. Read/Write.

[ API set: ExcelApi 1.8 ]

categoryLabelLevel?: number;

Property Value

number

chartType

Represents the type of the chart. See Excel.ChartType for details.

[ API set: ExcelApi 1.7 ]

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"

dataLabels

Represents the datalabels on the chart. Read-only.

[ API set: ExcelApi 1.1 ]

dataLabels?: Excel.Interfaces.ChartDataLabelsData;

Property Value

displayBlanksAs

Returns or sets the way that blank cells are plotted on a chart. Read/Write.

[ API set: ExcelApi 1.8 ]

displayBlanksAs?: Excel.ChartDisplayBlanksAs | "NotPlotted" | "Zero" | "Interplotted";

Property Value

Excel.ChartDisplayBlanksAs | "NotPlotted" | "Zero" | "Interplotted"

format

Encapsulates the format properties for the chart area. Read-only.

[ API set: ExcelApi 1.1 ]

format?: Excel.Interfaces.ChartAreaFormatData;

Property Value

height

Represents the height, in points, of the chart object.

[ API set: ExcelApi 1.1 ]

height?: number;

Property Value

number

id

The unique id of chart. Read-only.

[ API set: ExcelApi 1.7 ]

id?: string;

Property Value

string

left

The distance, in points, from the left side of the chart to the worksheet origin.

[ API set: ExcelApi 1.1 ]

left?: number;

Property Value

number

legend

Represents the legend for the chart. Read-only.

[ API set: ExcelApi 1.1 ]

legend?: Excel.Interfaces.ChartLegendData;

Property Value

name

Represents the name of a chart object.

[ API set: ExcelApi 1.1 ]

name?: string;

Property Value

string

pivotOptions

Encapsulates the options for a pivot chart. Read-only.

[ API set: ExcelApi 1.9 ]

pivotOptions?: Excel.Interfaces.ChartPivotOptionsData;

Property Value

plotArea

Represents the plotArea for the chart.

[ API set: ExcelApi 1.8 ]

plotArea?: Excel.Interfaces.ChartPlotAreaData;

Property Value

plotBy

Returns or sets the way columns or rows are used as data series on the chart. Read/Write.

[ API set: ExcelApi 1.8 ]

plotBy?: Excel.ChartPlotBy | "Rows" | "Columns";

Property Value

Excel.ChartPlotBy | "Rows" | "Columns"

plotVisibleOnly

True if only visible cells are plotted. False if both visible and hidden cells are plotted. Read/Write.

[ API set: ExcelApi 1.8 ]

plotVisibleOnly?: boolean;

Property Value

boolean

series

Represents either a single series or collection of series in the chart. Read-only.

[ API set: ExcelApi 1.1 ]

series?: Excel.Interfaces.ChartSeriesData[];

Property Value

seriesNameLevel

Returns or sets a ChartSeriesNameLevel enumeration constant referring to the level of where the series names are being sourced from. Read/Write.

[ API set: ExcelApi 1.8 ]

seriesNameLevel?: number;

Property Value

number

showAllFieldButtons

Represents whether to display all field buttons on a PivotChart.

[ API set: ExcelApi 1.7 ]

showAllFieldButtons?: boolean;

Property Value

boolean

showDataLabelsOverMaximum

Represents whether to show the data labels when the value is greater than the maximum value on the value axis. If value axis became smaller than the size of data points, you can use this property to set whether to show the data labels. This property applies to 2-D charts only.

[ API set: ExcelApi 1.8 ]

showDataLabelsOverMaximum?: boolean;

Property Value

boolean

style

Returns or sets the chart style for the chart. Read/Write.

[ API set: ExcelApi 1.8 ]

style?: number;

Property Value

number

title

Represents the title of the specified chart, including the text, visibility, position, and formatting of the title. Read-only.

[ API set: ExcelApi 1.1 ]

title?: Excel.Interfaces.ChartTitleData;

Property Value

top

Represents 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).

[ API set: ExcelApi 1.1 ]

top?: number;

Property Value

number

width

Represents the width, in points, of the chart object.

[ API set: ExcelApi 1.1 ]

width?: number;

Property Value

number