Pivot charts

Pivot chart comparing multiple aggregated series

In the default charting mode, you can easily create a simple chart with selected columns on both axes. However, creating a chart that compares multiple series (like the screenshot above) requires enabling the pivot mode by using the toggle at the top of the chart.

Toggle pivot mode

Once enabled, you will see that the Set Up tab has changed. Instead of choosing a category and series, you can now additionally choose Color by and Group by fields.

For this guide, we will try to recreate the chart in the top screenshot and assume a dataset about car sales with the following structure:

brand	year	nb_sales
Ford	2025	5791
Ford	2024	3381
Toyota	2025	4002
Toyota	2024	5821
...	...	...

Note: the number of sales are imaginary numbers.

1. Color by

The "Color by" field decides which column your data will be pivoted on. In other words, the data will be split into the values of the column you choose here, and each value will be represented with a unique color. In our example, let's pick the brands column because we want to see the number of sales per brand.

Note: this is the equivalent of the "Color" field in the legacy chart configuration.

2. Series

Similarly to the normal charting mode, series are the numerical values you want to chart. When adding a series, you'll first have to select the column. Additionally, since the data is being pivoted, you must also choose an aggregate. By default this will be set to average.

3. Group by

Finally, you can optionally choose to group your data by a specific column. It's a way to split your data into different segments on top of the "Color by" field. In this example we can choose to group the data by year so that we can see the trends.

Finally, in the Chart tab, don't forget to change the chart type from a bar chart to a line chart.