graph multiple data ranges
 

I have two worksheets with the same column/row headings, just different data
for different years. I have created bar graphs for each individual year to
see where income, etc fluctuated w/in the year. However, I'd like to create
a bar graph on a different worksheet that would show, for example Oct 2004
through Oct 2005, so we see the entire year's fluctuations and can compare
the current month to the same month last year. It seems like it should be
simple, but I can't figure it out. Is it possible? Thanks! Lindy

graph multiple data ranges
 

Does this help?

http://peltiertech.com/Excel/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

lindy.coyle wrote:

I have two worksheets with the same column/row headings, just different data
for different years. I have created bar graphs for each individual year to
see where income, etc fluctuated w/in the year. However, I'd like to create
a bar graph on a different worksheet that would show, for example Oct 2004
through Oct 2005, so we see the entire year's fluctuations and can compare
the current month to the same month last year. It seems like it should be
simple, but I can't figure it out. Is it possible? Thanks! Lindy