Displaying multiple columns on an area chart axis

[Anonymous]

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

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, select the first 2 columns, right click and select "Unpivot other columns".  Now build your chart.

[Anonymous]

Hi Ashish, I appreciate the response!

I'm noticing that this seems to duplicate lots of my other information, so some data which displays sums is coming up incorrect. Is there any way around this? 

[Ashish_Mathur]

Hi,

Those measures will have to be modified.  Share more details to get specific help with those measures.

[Anonymous]

Hi Ashish,

I made it work with your original advice. I appreciate your help! 

Take care,

-Matt

[Ashish_Mathur]

You are welcome.