Cluster Column Pivot Chart
 

I'm trying to create a column pivot chart that will have a different
column for each category with in a group.

I can genearte the pivot table so it comes out like this:

Time Fruit Total
Q1 sum of apple 3
sum of oranges 2
sum of grapes 2
Q2 sum of apple 0
sum of oranges 1
sum of grapes 3
Q3 sum of apple 1
sum of oranges 3
sum of grapes 5

When I create a pivot chart, it correctly shows the groups (apples,
oranges, grapes) for each quarter, but the chart is just one series
and color.

Is there a way to create a cluster column pivot chart that would allow
for different colors for each group (apples, oranges, grapes)?

Thanks!

John