Pie Chart with repeating categories

[bujaman]

I want to create a pie chart from a list of financial data. Each data point is categorized, and often times those are repeated (some are categorized as sales, others are returns, etc). When I create the chart, it makes a slice for each data point, instead of one per category. So, I have multiple sales slices, and multiple returns slices. Is there a way to easily combine all the slices with the same category?

 

[GlennUK]

Use a pivottable to summarize your data, and chart that.