Pivot charts aggregate and display charts based on column dimensions and row dimensions.

2.1 Common use cases #

Pivot charts categorize and summarize charts, enabling cross-analysis through different combinations. For example, compare the performance of prices in each quarter across different regions and product categories.

2.2 Usage example #

Step 1: Configure the chart

Step 2: Configure classification dimensions
The configured column dimensions display charts for each dimension item in columns, and the configured row dimensions display charts for each dimension item in rows.

Step 3: Set the pivot style (whether to show row and column headers) and display mode

When there are many pivot dimension items, the chart may exceed the screen display range. You can select from standard, fit to width, fit to height, or fit to window.

Supported chart types : Column chart, bar chart, line chart, area chart, dual-axis chart, combination chart
Configure column dimensions : You can configure one or more column dimensions. Drag dimensions into the column dimensions area of the pivot chart.

Configure row dimensions : You can configure one or more row dimensions. Drag dimensions into the row dimensions area of the pivot chart.