I have one data source with multiple columns - for the purpose of this question, the column I'm concerned about is Category.
The Category has several choices available - Cat 1, Cat 2, Cat 3, Cat 4, Cat 5, Cat 6 & Cat 7.
I need to display scores from Cat 1, 2, 3 and 5 as a pie chart, so I have...