W
whowhat
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.
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.