Forum Discussion
How to graphic a Matrix
Im new in this, please help me to graphic this. If you can not see the image i will explain. In the first column I have listed for steel members...mark 1, mark 2, mark 3, etc... The areas wh...
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.
moumipanja
Microsoft Employee
Microsoft EmployeeAnonymous I am glad that it helped. Could you please mark my post as a solution