Creating Stacked column chart with more than one X-axis

[vickychill]

Hello community,

I have a table something like below and want to show the data as below for each year in one column chart. I read people suggesting to unpivot the table but the table is huge (with more than 10K rows) and will make this complex. Is there an easier way to do this?

Product ID	Sales 2021	Sales 2022	Sales 2023
1	100	102	104
2	200	200	210
3	300	350	360
4	400	401	420

Thank you in advance.

[Ashish_Mathur]

Hi,

Unpivoting is the only and therefore the best way.