Creating a stacked column graph
 

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

Creating a stacked column graph
 

I will need step by step instructions on how to create this kind of
graph.Sorry am new to graphing.


On Jun 30, 3:28*pm, Srikanth wrote:
Guys
Am looking to create astackedcolumngraph. Can someone help me with
this.
Am attaching an excel spreadsheet with the required columns in it.

My requirement is::

Add astackedcolumngraphwith 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 thisgraphand
how can i insert the values into X,Y and Z axis.

Thanks
Sri

Creating a stacked column graph
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Srikanth" wrote in message
...
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