How to make pie charts from infomation from drop-down lists.

Good day

I have a problem with creating a specific pie chart with information from Drop-down lists that i have created. I have an example of what it should be like but I don't know how to do it due to it being password protected and cannot see the steps to follow in order to complete it.

Please I am in desperate need for help.

Could you post the example so we can see what you're trying to achieve?

BSB

Here is the example

Have a look at the now unhidden columns N:P on the Template sheet of the attached to see how it's done.

If you need any of it explaining then ask.

BSB

Hi BSB

I just want to say thank you very much. This helps me tremendously.

Not a problem. Happy to help.

BSB

I have got another question.

I want to create a Pie Chart with multiple worksheets data, but when i try it, i still have to choose between sheets but with the same info i can make all the other charts work. . Is it possible to have a FINAL PIE CHART with the percentage of all the worksheets data and if so how?

I will attache my workbook.

I'm not sure I understand the need exactly. Could you explain a little more?
Which data exactly do you need to add to the final pie chart?

BSB

From sheet ALT to URIC ACID there are 3 pie charts on each sheet.
1. Root cause
2. EQC
3. DQC

I need a Final Pie Chart that have all the
First chart (Root cause from ALT to URIC ACID)
Second chart (EQC FROM ALT TO URIC ACID)
Third chart (DQC FROM ALT TO URIC ACID)

so I have the percentage off the Root causes on one chart, EQC on another and DQC on another.

Does that make sense?

Now i have a pie chart that i still have to pick the Value series to get only one sheets percentage. It should only be one series for all the sheets from ALT to URIC ACID.


(I havn't done a Final EQC or DQC chart yet)