For the pie chart I used the data from the pivot table and designed it using Adobe Illustrator.