Cluster Column Pivot Chart

R

robotman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top