financial excel course london - Pivot tables

Hi Chris

Thank you for your question, and apologies for the delay in response.

I think what you are asking, is that if you are creating pivot charts, can you change the colours used in the chart then use these colours you have selected as the default formatting for all pivot charts so you don't need to make the same formatting changes every time a pivot chart is created.

If that is the case, what you can do is apply the colours you want to use to a pivot chart, then right-click in the Plot or Chart Area and select Chart type. Go to the Custom Types tab, click the Set as Default Chart button at the bottom of the dialogue box, give your chart a name and click OK.

Now each pivot chart you create should have the same colour applied automatically. I'm not sure if this works across different Excel files, I haven't tried it but works in one Excel file if you are making more than one chart.

I hope this helps.
Amanda