PivotToolbarInfo

9 Jul 20261 minute to read

Defines the current toolbar information such as current display options and its settings such as chart settings, grid settings, etc.

Properties

chartSettings ChartSettings

Defines the pivot chart settings such as chart series, chart area, axis labels, legends, border, crosshairs, theme, title, tooltip, zooming, etc.

chartType ChartSeriesType

Defines the chart series type

displayOption DisplayOption

Defines the current display settings such as current view port as either pivot table or pivot chart or both table and chart.

enableMultipleAxis boolean

Defines whether multiple axis is enabled.

grandTotalsPosition GrandTotalsPosition

Defines the grand totals position (Top or Bottom).

gridSettings GridSettings

Defines the pivot table settings such as column width, row height, grid lines, text wrap settings, selection settings, etc.

legendVisible boolean

Defines whether legend is visible.

multipleAxisMode MultipleAxisMode

Defines the multiple axis mode (Stacked, Single, Combined).

showColumnGrandTotals boolean

Defines whether to show or hide grand totals in the column axis of the pivot table.

showColumnSubTotals boolean

Defines whether to show or hide sub-totals in the column axis of the pivot table.

showGrandTotals boolean

Defines whether to show or hide grand totals in both row and column axes of the pivot table.

showRowGrandTotals boolean

Defines whether to show or hide grand totals in the row axis of the pivot table.

showRowSubTotals boolean

Defines whether to show or hide sub-totals in the row axis of the pivot table.

showSubTotals boolean

Defines whether to show or hide sub-totals in both row and column axes of the pivot table.

subTotalsPosition SubTotalsPosition

Defines the sub-totals position (Top, Bottom, or Auto).