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.
