Bar chart - with cumulative and comparison

[Kevin Kuan]

Hi, All,

I have a question in drawing an Excel bar chart. How can I draw a bar chart
with cumulative value at a bar and a bar next to it is another year's data.
For example, if we have to following raw data:

Year 2001
1st Quarter 2nd Quarter 3th Quarter 4th Quarter

Sales A 5 20 77 16
Sales B 8 25 22 2
Sales C 12 44 44 5
Sales D 55 11 22 5


Year 2002
1st Quarter 2nd Quarter 3th Quarter 4th Quarter

Sales A 9 20 55 29
Sales B 28 4 20 4
Sales C 16 7 4 3
Sales D 5 60 18 2



The chart should be a total of 8 bars - four for the year 2001 and four for
the year 2002. Each bar should have the values of Sales A, B, D, and D. The
bar for the 1st Quarter of Year 2002 should be next to the 1st Quarter of
Year 2001 for comparison.

Thanks for your help!

Kevin