Excel.Interfaces.ChartUpdateData interface
An interface for updating data on the Chart object, for use in chart.set({ ... }).
Properties
| axes | Represents chart axes. |
| category |
Specifies a chart category label level enumeration constant, referring to the level of the source category labels. |
| chart |
Specifies the type of the chart. See |
| data |
Represents the data labels on the chart. |
| display |
Specifies the way that blank cells are plotted on a chart. |
| format | Encapsulates the format properties for the chart area. |
| height | Specifies the height, in points, of the chart object. |
| 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. |
| pivot |
Encapsulates the options for a pivot chart. |
| plot |
Represents the plot area for the chart. |
| plot |
Specifies the way columns or rows are used as data series on the chart. |
| plot |
True if only visible cells are plotted. False if both visible and hidden cells are plotted. |
| series |
Specifies a chart series name level enumeration constant, referring to the level of the source series names. |
| show |
Specifies whether to display all field buttons on a PivotChart. |
| show |
Specifies whether to show the data labels when the value is greater than the maximum value on the value axis. If the value axis becomes smaller than the size of the data points, you can use this property to set whether to show the data labels. This property applies to 2-D charts only. |
| style | Specifies the chart style for the chart. |
| 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.ChartAxesUpdateData;Property Value
Remarks
categoryLabelLevel
Specifies a chart category label level enumeration constant, referring to the level of the source category labels.
categoryLabelLevel?: number;Property Value
number
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.ChartDataLabelsUpdateData;Property Value
Remarks
displayBlanksAs
Specifies the way that blank cells are plotted on a chart.
displayBlanksAs?: Excel.ChartDisplayBlanksAs | "NotPlotted" | "Zero" | "Interplotted";Property Value
Excel.ChartDisplayBlanksAs | "NotPlotted" | "Zero" | "Interplotted"
Remarks
format
Encapsulates the format properties for the chart area.
format?: Excel.Interfaces.ChartAreaFormatUpdateData;Property Value
Remarks
height
Specifies the height, in points, of the chart object.
height?: number;Property Value
number
Remarks
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.ChartLegendUpdateData;Property Value
Remarks
name
Specifies the name of a chart object.
name?: string;Property Value
string
Remarks
pivotOptions
Encapsulates the options for a pivot chart.
pivotOptions?: Excel.Interfaces.ChartPivotOptionsUpdateData;Property Value
Remarks
plotArea
Represents the plot area for the chart.
plotArea?: Excel.Interfaces.ChartPlotAreaUpdateData;Property Value
Remarks
plotBy
Specifies the way columns or rows are used as data series on the chart.
plotBy?: Excel.ChartPlotBy | "Rows" | "Columns";Property Value
Excel.ChartPlotBy | "Rows" | "Columns"
Remarks
plotVisibleOnly
True if only visible cells are plotted. False if both visible and hidden cells are plotted.
plotVisibleOnly?: boolean;Property Value
boolean
Remarks
seriesNameLevel
Specifies a chart series name level enumeration constant, referring to the level of the source series names.
seriesNameLevel?: number;Property Value
number
Remarks
showAllFieldButtons
Specifies whether to display all field buttons on a PivotChart.
showAllFieldButtons?: boolean;Property Value
boolean
Remarks
showDataLabelsOverMaximum
Specifies whether to show the data labels when the value is greater than the maximum value on the value axis. If the value axis becomes smaller than the size of the data points, you can use this property to set whether to show the data labels. This property applies to 2-D charts only.
showDataLabelsOverMaximum?: boolean;Property Value
boolean
Remarks
style
Specifies the chart style for the chart.
style?: number;Property Value
number
Remarks
title
Represents the title of the specified chart, including the text, visibility, position, and formatting of the title.
title?: Excel.Interfaces.ChartTitleUpdateData;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
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