Pivot table color chart

[feejo]

I make a pivot table but the bar chart is one color, how to have it in different color

[jevni1974]

hi feejo,

If you want to change the color all bars in your graph:

1. Right-click on a the bar
2. Select 'Format data series' form the popup menu
3. In the window that opens, select the Patterns tab.

If you want to change the color of an individual bar in your graph:

1. Click on the bar you want to change.
2. Click on it again
3. Right-click on it
4. Select 'Format data point' form the popup menu
5. In the window that opens, select the Patterns tab.

There you can change the looks of the bar of one data point.
In case you want to change the color of all bars in the graph you have to perform the steps mentioned above for each bar.

hope this helps.