Static Pie/Donut Chart Legend

[Anonymous]

I am creating a report to show the status of multiple projects, and I'm having trouble with creating a pie/donut chart. The chart will display the status (Does Not Apply, Not Started, In Process, Complete) for each role (ME, QE, MR, PC, TL) working on the project. 

When creating the pie/donut chart, I'm not sure what to use for the legend. I've tried using the ME column, but if the ME column does not contain each of the status options, this will no longer work. I've also tried creating a separate table that contains a "Statuses" column with each of the status options, but I can not get it to work. If you need more explanation I will try my best to clarify the issue. Thank you in adavance for any help you can offer.

[Anonymous · Accepted solution]

You could try the following in Edit Queries:

Select ME, QE, MR, PC, TL -> Transform - > Unpivot Columns -> Only seclected columns. 

Once you do this, you will get the following:

Then you can use the Atrribute column as Legend in your pie chart. Hope this helps!