Pie Diagram from data across multiple work sheets
 

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?

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

"Harry" wrote:

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?

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

"bj" wrote:

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

"Harry" wrote:

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?

Then Sorry , I don't know how

"Harry" wrote:

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

"bj" wrote:

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

"Harry" wrote:

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?

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/ChartsH...iffSheets.html

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

Harry wrote:

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

"bj" wrote:


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

"Harry" wrote:


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?