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
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