Excel.Interfaces.ChartDataTableUpdateData interface

Package:

excel

An interface for updating data on the ChartDataTable object, for use in chartDataTable.set({ ... }).

Properties

format	Represents the format of a chart data table, which includes fill, font, and border format.
showHorizontalBorder	Specifies whether to display the horizontal border of the data table.
showLegendKey	Specifies whether to show the legend key of the data table.
showOutlineBorder	Specifies whether to display the outline border of the data table.
showVerticalBorder	Specifies whether to display the vertical border of the data table.
visible	Specifies whether to show the data table of the chart.

Property Details

format

Represents the format of a chart data table, which includes fill, font, and border format.

format?: Excel.Interfaces.ChartDataTableFormatUpdateData;

Property Value

Excel.Interfaces.ChartDataTableFormatUpdateData

Remarks

[ API set: ExcelApi 1.14 ]

showHorizontalBorder

Specifies whether to display the horizontal border of the data table.

showHorizontalBorder?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

showLegendKey

Specifies whether to show the legend key of the data table.

showLegendKey?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

showOutlineBorder

Specifies whether to display the outline border of the data table.

showOutlineBorder?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

showVerticalBorder

Specifies whether to display the vertical border of the data table.

showVerticalBorder?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]

visible

Specifies whether to show the data table of the chart.

visible?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.14 ]