This may give you some insight:

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

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


"my" wrote in message
...
Hi,

I've reached the last column in my file and I need my graph to continue
graphing combing two files. Is this possible? So for example, my current
file ends in column IV, data is ends 12/31/06. I need to keep graphing
for
the new year also. Is there a way to start a new file, data begins 1/1/07
and
have the chart graph continuously?

Thanks in advance!