Guys
Am looking to create a stacked column graph. Can someone help me with
this.
Am attaching an excel spreadsheet with the required columns in it.

My requirement is::

Add a stacked column graph with build value on the horizontal axis and
volume on the vertical. Collapse data points into:Closed (3 closed
status values), New, In Progress (In Progress + Ready for Build +
Ready for Release), Ready for Test. Split the columns by severity.

Please help me with this one.How to go about creating this graph and
how can i insert the values into X,Y and Z axis.


Thanks
Sri