Three Google Sheets' data graphs (pie charts) in one graph

Question

I have three google sheets of data in one spreadsheet. these sheets containing the data of ABC Town students. ABC Town has 3 Streets called Street 1, Street 2 and Street 3.

• Street 1 has 10 Students in different grades.
• Street 2 has 6 Students in different grades.
• Street 3 has 2 Students in different grades.

Every sheet has Students Grade summary Pie Graph. Now What I need is, I have to combine these three pie charts into one chart to get a final summary of three sheets. how can I do this? Please.

This is my spreadsheet: https://docs.google.com/spreadsheets/d/1NmCSRPaoGCpuyfxv24z2-M8TNktBjHNt7BoaMF6LCJY/edit?usp=sharing

explained in image:

Answer 1

or maybe you just want to combine all 3 charts (?) like:

demo spreadsheet