Data from 3 different sheets in the same workbook

M

Marta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
Doughnut Chart linked with the slicer in the pivot table 0
Embed the same Excel multiple times 0
Create a chart from a table in word thats dynamic 0
selecting workbook/sheet 3
How to list cells from two sheets that has different values in theirneighboring column? 8
Copy Data from One sheet to Different Sheets 1
Creating a Chart on form from selected data in query. 0

Top