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.

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.