Stacked bar graph

[bodrules]

Hi,

I have an issue, that may have been discussed on this board before, but I haven't been able to locate any discussions on.

Essentially I have the following data set

2007 2008
XX YY XX YY
cat 1 74 3,681 79 3,806
cat 2 565 2,835 597 2,886
cat 3 987 98,658 1,044 103,284
cat 4 129 2,612 127 2,618


I want to compile a stacked column chart for 2007 and 2008, using the 4 categories on the Y axis, and the % on the X axis

Now I can do this easilt if i restrict myself to the 2007 dataset, but trying to get it to do both 2007 and 2008 is making me utilise the cranial digit on the desktop, any pointers or tips are most gratefully accepted.

 

[Derek Brown]

If I want to do something clever with a chart, I will go to Jon Peltier's web site:
http://peltiertech.com/Excel/Charts/ChartIndex.html
You will find examples (often with downloadable workbooks) of many chart types including 'stacked'.