Forum Discussion
Displaying multiple columns on an area chart axis
Hi folks,
I'm currently attempting to create an area chart using a matrix of project spending over a time period, with the catagories displayed as lines (See attached). I'm not sure how to do this, and am turning to the experts for assistance! It would be nice to have it tie into my existing data on the page, updating other fields when clicked on, but I understand if this is not possible.
Cheers!
| Type | 2021 | 2022 | 2023 | 2024 | |
| Item 1 | Type 1 | $xx | $xx | ||
| Item 2 | Type 2 | $xx | $xx | $xx | |
| Item 3 | Type 2 | $xx | |||
| Item 4 | Type 3 | $xx | $xx | ||
| Item 5 | Type 4 | $xx | $xx | ||
| Item 6 | Type 3 | $xx | $xx | $xx |
Hi,
In the Query Editor, select the first 2 columns, right click and select "Unpivot other columns". Now build your chart.
5 Replies
- Ashish_Mathur
Super User
Hi,
In the Query Editor, select the first 2 columns, right click and select "Unpivot other columns". Now build your chart.
- Ashish_Mathur
Hi,
Those measures will have to be modified. Share more details to get specific help with those measures.