thomasuponor
New Member
- Joined
- Sep 13, 2018
- Messages
- 44
- Office Version
- 2016
- Platform
- Windows
I am trying to create a bar chart with below clusters.
Blue = 2020
Orange 2021
The data comes from Excel:
So far I have done this:
Step 1: Query Editor
Step 2: Selected all the columns except Year and click on "Unpivot Columns" under Transform tab.
Now I am lost![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Blue = 2020
Orange 2021
The data comes from Excel:
Year | 0-100.000 | 100.000-500.000 | 500.000-1.000.000 | >1.000.000 |
2020 | 37,13% | 40,0% | 33,33% | 33,33 |
2021 | 47,45% | 36,41% | 29,27% | 20,59 |
So far I have done this:
Step 1: Query Editor
Step 2: Selected all the columns except Year and click on "Unpivot Columns" under Transform tab.
Now I am lost