Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Data based on Month and Year | Excel Worksheet Functions | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
Compare month to month data | Excel Worksheet Functions | |||
Showing data per month & year for comparison | Excel Discussion (Misc queries) | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel |