Creating a stacked column graph

  • Thread starter Thread starter Srikanth
  • Start date Start date
S

Srikanth

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
 
I will need step by step instructions on how to create this kind of
graph.Sorry am new to graphing.
 
First set up the data, or you will be wasting your time. Here is a typical
"good" layout:

Y1 Y2 Y3 Y4 Y5
X Label 1 ## ## ## ## ##
X Label 2 ## ## ## ## ##
X Label 3 ## ## ## ## ##
X Label 4 ## ## ## ## ##

The top left cell is blank.

Select this data, create the chart, select stacked column type, choose
series in columns. Don't use a 3D chart type; it will be difficult to
interpret.

- Jon
 
Back
Top