bar chart to compare month and year data
 

I would like to creat an excel chart that overlays totals for two years for
different categories.

Here is the data

2007 columnheader1 columnheader2 columnheader3 Total
Jan 1 1 2
4
Feb 2 0 1
3
March 1 1 4 6


2006 columnheader1 columnheader2 columnheader3 Total
Jan 2 4 2
8
Feb 2 3 1
6
March 1 3 5 9

I want to have each column header as a column graphed grouped by month and
over lay 2006 onto 2007. I am able to get one year to display properly using
a pivot table as the source of the chart data. I am struggling on how to
overlay the two years on top of each other.