bar chart to compare month and year data

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top