View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ndavies
 
Posts: n/a
Default 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