Forum Discussion
How to graphic a Matrix
1. Go to Edit Queries, select columns Area A, Area B, Area C, Area D. Right click and select Unpivot Only Selected Columns. You will get a table like this from your original table.
2. Select Status and Attribute column. Right click and select Group By -> Advanced. Add new column name as SUM, select Operation as Sum and Column as Value. You will get a table like this.
3. Select close and apply to exit from Edit Queries. Select Stacked Bar Chart, keep Attribute in Axis, Status in Legend and SUM in Value.
1. Go to Edit Queries, select columns Area A, Area B, Area C, Area D. Right click and select Unpivot Only Selected Columns. You will get a table like this from your original table.
2. Select Status and Attribute column. Right click and select Group By -> Advanced. Add new column name as SUM, select Operation as Sum and Column as Value. You will get a table like this.
3. Select close and apply to exit from Edit Queries. Select Stacked Bar Chart, keep Attribute in Axis, Status in Legend and SUM in Value.
Thank you! It worked perfectly.
Anonymous I am glad that it helped. Could you please mark my post as a solution