Pie Charts?

[MRSpickles]

I am currently taking an Excel class through my local community college and I'm hoping to receive and answer regarding my question.
Is there a way and how do you do it, create a pie chart using data across multiple sheets in the same workbook? If this was something we did in class, I missed it. But I'm hoping it's a smooth and simple way to do this!
Thank you!

 

[Sergius]

Hello! Everything is possible. See the photo. The structure of the sheets is the same. Data from all sheets is displayed on one circular diagram.

 

[myall_blues]

Strictly speaking no, because a 'pie' chart can only have one data series.
To reproduce the diagram shown by @Sergius you need to use a 'doughnut' chart. For clarity I've shown two data series on one sheet but the principle is the same if the additional series are on separate sheets.
Here are the data:

Book1
	A	B	C
1		Oct-23
2	SB Prod Cash in	1200
3	SB Brand Cash in	21777
4	Misc cash in	211285
5	SB Prod Cash out	1009
6	SB Brand Cash out	20032
7	Misc cash out	223320
8
9		Nov-23	<== These data would be on a separate sheet.
10	SB Prod Cash in	1200
11	SB Brand Cash in	21777
12	Misc cash in	211285
13	SB Prod Cash out	1009
14	SB Brand Cash out	20032
15	Misc cash out	223320
Sheet1

Select A2:B7, then Insert tab->Charts group->Select the pie chart dropdown and select doughnut
Now select B10:B15, Copy, then right click in the chart and select Paste Special, add cells as new series and click OK

Repeat for additional series/sheets.

This will produce a chart like so. You can adjust the thickness of the rings, colours etc.

Having said all this I see you may be using the web-based version of Excel so some of this functionality will not be available.