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

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


"JNW" wrote in message
...
i have a workbook that has a sheet for each year of data. We want to
create
a rolling 15 month chart that graphs the trend over 15 months starting
with
the specified month. The problem is that the information is on two
different
sheets and Excel doesn't like that.

Is there anyway around this without creating a summary sheet to include
both
year's info?

thanks!
--
JNW