Need Help Putting Together A Stacked Bar Chart

[JohnPW]

I know there is a simple answer for this but nothing seems to be working and I have a deadline to meet today. I have the following data:

2006 2007 2008
1A 10 20 25
1B 50 60 55
1C 65 60 75
2A 15 12 8
2B 45 50 40
2C 70 65 60
3D 5 10 15

Trying to create a stacked bar chart that looks like this:

2006 2007 2008
10 15 20 12 25 8
50 45 60 50 55 40
65 70 5 60 65 10 75 60 15


Any suggestions are greatly appreciated! Thanks!

 

[Andrew Poulsom]

Why have you put data for 3D on the last line rather than the first?

 

[JohnPW]

Sorry, I wanted it to look someting like this. The data in 3D is completely separate from the rest of the data. The data in 3D will not be stacked.

200611111111120071111111112008
1011151111111201112111111125118
50114511111116011501111111551140
651170115111160116511101117511601115

Hope this makes a little more sense. Thanks!

 

[Andrew Poulsom]

Set out your data like this:

     Val1  Val2  Val3
2006   10    50    65
       15    45    70
        5
2007   20    60    60
       12    50    65
       10
2008   25    55    75
        8    40    60
       15