How to graphic a Matrix

[Anonymous]

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 where those steel members will be sent are many, so I put in every columnn a facility name with its quantity. the columns are Area A, Area B, Area C...etc. The marks are not restricted to facilities, so they can be sent in different numbers to more than one facility. Also, in the final column I have the status of every mark...In review, Released,

How can i praphic it?

I want a stacked bar chart with facilities in Y axis, number of pieces by facility in X axis, and inside the color of the different status of theses pieces. Somenthing as it shows below (it is a random drawing so it may not match with the table).

Thank you!

[moumipanja · Accepted solution]

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. 

[Anonymous]

Thank you! It worked perfectly.

[moumipanja]

@Anonymous I am glad that it helped. Could you please mark my post as a solution