Dynamic Pie Chart with Control Box....help!

Hello All,

First off I want to say sorry if this question sounds complicated and I will try my best to explain what I am trying to do. (I am using different data IRL which is company sensitive so I have designed a simple example spreadsheet.)

Ok, So I have a list of words A2:A4 and I have created a Control Box which allows me to select which word I want from the list.

On a separate tab I have lists of data which relates to individual words from the A2:A4 list.

What I what to achieve is when the word is selected from the drop down menu it will create a Pie chart showing me the break down of percentages and attributing 'companies'. (Please hopefully see example document attached.)

Thank you for your time and I appreciate any help anyone can offer.

Chris

Does no-one on here have any suggestions??? If there is another way to achieve the same results please let me know too....

Thanks

Hi Andy,

Yes, that layout is pretty similar, might not be the exact alignment within the spreadsheet but it was as a example.

I have around 25-50 rows in my data set. (I am doing market analysis for our Google campaigns and keywords driving traffic to our site, but also market split of who else is getting traffic from search terms.)

As this is private data, my example is a really simple but accurate test.

Finally yes it would be out of 100% for arguments sake.

Again I hope this makes sense, if not please ask and thanks again for any help.

Thanks thats prefect!

However I'm trying to duplicate the chart setup in my master workbook however doesn't seem to work??

I have created tables, then made a master table using the =CHOOSE(DATA_P1,DATA_P2) etc formula but I seem to be missing something since how does the chart know which data to select.

eg: If Apples is selected how does the CHT_DATA formula know to look at the correct DATA_P and LABELS_P tables for the Apple information??

I hope that makes sense...

Thanks again