You can have a chart where different data series live on different
worksheets.
But it sounds as if you want to take one point from Sheet!, another from
Sheet2, etc.
Why not make a table such as:
Col X(values) Col Y (formulas)
2002 =Sheet1!C40
2003 =Sheet2!D56
etc
Then make chart from this data (which could be off in an unused part of the
sheet)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Link" wrote in message
...
I am trying to create a line graph from multiple worksheets, within the
same file. I have a budget with each year on a separate worksheet, but I
need a graph showing the five year trends.

I am using Microsoft Excel 2003 (11.8120.8122) SP2.

Maybe I am using the wrong type of line graphs? Maybe there's a trick?
Maybe it can't be done? Any help greatly appreciated.

Cheers,
Link.