Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
multi stacked column chart
Using Excel 2003, I need to show monthly work orders...one stacked column
should show work orders opened (for high, medium and low priority status) and another stacked column should show work orders closed (for high, medium and low priority status).....on the same chart. I can't get two stacked columns on the same chart...the six pieces of data stack in one column. I would appreciate any help you can give me. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
multi stacked column chart
Try setting the data up similar to this:
Open Closed High 4 2 Medium 6 4 Low 5 3 In step 1 of the Chart Wizard, choose the stacked column chart. In step 2 of the Chart Wizard, select the "Series in Rows" option. -- John Mansfield http://cellmatrix.net "Marge Sutko" wrote: Using Excel 2003, I need to show monthly work orders...one stacked column should show work orders opened (for high, medium and low priority status) and another stacked column should show work orders closed (for high, medium and low priority status).....on the same chart. I can't get two stacked columns on the same chart...the six pieces of data stack in one column. I would appreciate any help you can give me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column chart wit more than one column in a data point | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
How to combine stacked column with a cluster column chart? | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |