View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Link Link is offline
external usenet poster
 
Posts: 14
Default Can I create a chart from multiple worksheets in the same Excel file?

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.