Charts

Here is the workbook with my sample charts.

I was having some trouble because even though I was selecting the data from my cleaned data sheet, the pivot table kept showing the original data's categories. I closed out and refreshed and tried again and it continued to happen.