Hi,

I want to change the formatting imposed by default in a pivot chart and I
want that changed formatting to be retained permanently.

For example, for my bar chart, for the different series I have selected
colours / patterns but every time I refresh the pivot table / chart; excel
falls back to its own colour coding.

Any way to get around this?

Many thanks in anticipation.

Not directly. The only way to simulate this is to record a macro of the
formatting changes that you make and then set it up to run whenever the
PivotChart calculates. Assuming your pivot chart is on a seperate sheet,
right click on sheet tab and put something like this in:

Option Explicit
Private Sub Chart_Calculate()

'Insert your recorded macro here
'of the formatting changes that you need done.
'This will located in one of your modules

End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"DKS" wrote:

Hi,

I want to change the formatting imposed by default in a pivot chart and I
want that changed formatting to be retained permanently.

For example, for my bar chart, for the different series I have selected
colours / patterns but every time I refresh the pivot table / chart; excel
falls back to its own colour coding.

Any way to get around this?

Many thanks in anticipation.