Pie Chart Displaying Only Data Where a Condition is Met

Originally Posted by JosephP

have you tried a pivot chart?

also just be aware that pie charts are not generally well regarded in the world of data visualization :-)

No, have not tried a pivot chart. I'm not sure how to be honest. Any advice please?

I'v been asked to create a pie chart.