How can I display two seperate stacked bars in a graph
 

Hello,

I have the following data that I would like in a stacked bar graph but
with stacked bars for each year. I am unable to figure a way to do this
and hoping that someone would be kind enough to let me know if it can be
done and give any hints on how please?

1994 1995
0-50cm 50-100cm 0-50cmm 50-100cm
2 14 5 10
12 2 10 4
7 2 14 8
32 20 16 12
6 10 13 8

If I do this using graph wizard I get all the data for one year on one
bar


--
ndavies
------------------------------------------------------------------------
ndavies's Profile: http://www.excelforum.com/member.php...fo&userid=8746
View this thread: http://www.excelforum.com/showthread...hreadid=512955

How can I display two seperate stacked bars in a graph
 

see http://www.stfx.ca/people/bliengme/E...ps/Columns.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"ndavies" wrote in
message ...

Hello,

I have the following data that I would like in a stacked bar graph but
with stacked bars for each year. I am unable to figure a way to do this
and hoping that someone would be kind enough to let me know if it can be
done and give any hints on how please?

1994 1995
0-50cm 50-100cm 0-50cmm 50-100cm
2 14 5 10
12 2 10 4
7 2 14 8
32 20 16 12
6 10 13 8

If I do this using graph wizard I get all the data for one year on one
bar


--
ndavies
------------------------------------------------------------------------
ndavies's Profile:
http://www.excelforum.com/member.php...fo&userid=8746
View this thread: http://www.excelforum.com/showthread...hreadid=512955