Pie Diagram from data across multiple work sheets

[Harry]

I have a tabular data field across three work sheets in a single file. I need
to make use of this data to create a pie chart in a single sheet. How do I go
about this?

 

[bj]

can you reference the data on one sheet to consolidate your graph input data?

 

[Harry]

Unfortunately, I cant. These tables contain data across projects and so I
would prefer not to have them clubbed.

 

[bj]

Then Sorry , I don't know how

Unfortunately, I cant. These tables contain data across projects and so I
would prefer not to have them clubbed.

 

[Jon Peltier]

Why can't you use a separate worksheet for the "clubbed" data? An extra sheet with a
few formulas is a cheap and simple solution. Here's more information about charting
data from different sheets:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

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