Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column graph | Charts and Charting in Excel | |||
Stacked column graph | Charts and Charting in Excel | |||
Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
Creating a stacked column chart with percentage in the graph | Charts and Charting in Excel | |||
How do you combine a stacked column and single column graph? | Charts and Charting in Excel |