View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Pam Pam is offline
external usenet poster
 
Posts: 128
Default Charting information from nultiple work books

I have 4 different workbooks of information, with 12 (1 per month) tabs in
each workbook. On each tab I have about 40 lines of information that need to
be graphed. I am having great difficulty doing this. I am relatively new to
excel, so it's a little over whelming. Each tab has 11 expenses, 7 income
revenues for the current year, the previous year, YTD current year, YTD last
year, Variance and YTD variance. There a lot of informatin. i'm trying to
graph the information on a pie chart, trailing for 12 months. I need help
with how to display the right information in the best way possible. Anyone
have any ideas??