Forum Discussion
Solved
Creating a simple bar chart with multiple columns on the x-axis
I have a table which is looking something like this: Description Begin Date 2021 2022 2023 2024 Project 1 13.06.2021 400.000€ 450.000€ 450.000€ 0€ Project 2 01.01.2022 0€ ...
Hi MrBIn ,
This is not the best format for the data you need to go to the query editor select the columns of the years and then Unpivot columns
https://www.youtube.com/watch?v=GINbx-gOwNE
Now you just need to use the year on the legend.
MFelix
Super User
Super UserHi MrBIn ,
This is not the best format for the data you need to go to the query editor select the columns of the years and then Unpivot columns
https://www.youtube.com/watch?v=GINbx-gOwNE
Now you just need to use the year on the legend.
Thank you very much, this worked to solve my problem!