Dear Drew7ster,
I created a sample dataset to illustrate your issue. I'll create a pie chart using this dataset to show the percentages of each product type produced by each producer. In order to do this, I've made a drop-down list in Cell F20 that will periodically get the value of each...