| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data from 3 different sheets in the same workbook
We have to produce a pie chart on a new sheet which will show the percentage
total of 3 different data that are in 3 different sheets but the cell's still the same (B14 in sheet1, B14 in sheet2, B14 in sheet3). I hold the CTRL button but it doesn't work. Is there a way to create this piechart without linking the 3 data in a fourth sheet? We tried in a lot of different ways but they give us errors (one of them is "reference is not valid") Thanks |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Data from 3 different sheets in the same workbook
are there any limitations as to why you could not link to 4th sheet?
"Marta" wrote: We have to produce a pie chart on a new sheet which will show the percentage total of 3 different data that are in 3 different sheets but the cell's still the same (B14 in sheet1, B14 in sheet2, B14 in sheet3). I hold the CTRL button but it doesn't work. Is there a way to create this piechart without linking the 3 data in a fourth sheet? We tried in a lot of different ways but they give us errors (one of them is "reference is not valid") Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dividing Data between sheets in a workbook | Excel Worksheet Functions | |||
| moving data between workbook sheets | Excel Discussion (Misc queries) | |||
| Linking data in workbook to its sheets | Excel Worksheet Functions | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Workbook Summary Data from Sheets | Excel Worksheet Functions | |||
Linear Mode
