| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple scatter graphes how to plot 3 sets of data for x y on th. | Charts and Charting in Excel | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| Linking sheets when sorting row and column data | Excel Worksheet Functions | |||
| Summarise data on multiple sheets | Excel Worksheet Functions | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
