how to display the right information in the best way possible.

Well, I don't know what the right information is, but a pie chart can't
possibly be the best way if you have more than about five pieces of data.

Are you trying to display as a function of date? If so, you will have to get
all the data onto one worksheet. An easy way to do this that is pretty
reliable and accommodates changing information, is to copy each range of
data from the individual sheets, then select a cell in a new summary
worksheet, and use Paste Special to paste links.

Time series data (data that is tracked over time) is usually best done with
a line chart, though sometimes a column chart is okay.

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



"Pam" wrote in message
...
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??