Pivot table charts

Morning Rachel,

You can change the colours but you have to watch out how you change it.

Once you have your chart make the relevent changes and then go to Chart Menu, Chart Options, in the bottom right click on "Set as default chart". Everytime you then do a new chart it will keep your colours, but also any changes made to the pivot chart are changed. If you do not set the default then if you change anything on the pivot chart such as choosing different options then you will lose everything you have done. This would only apply if you have clicked bar etc and changed the colour.

If this is for everybody in the company then you would need to speak with the IT department as they would need to change the global template.

Hope this helps
Regards
Martin