Pivot Chart keeps going back to default format after refresh

[Jackdripah]

Hi All!

Is ther some way I can stop the pivot charts from going back to its default format after refreshing the pivot?

I have already changed the colors and fonts to my desired look but when I refresh the pivot is returns back to the default look.

Is there someway to do this without applying VBA program?

Thanks

 

[RoryA]

I assume you are using a version of Excel pre 2007? If so, then the answer is no, I'm afraid.

 

[Jackdripah]

I assume you are using a version of Excel pre 2007? If so, then the answer is no, I'm afraid.

It actually is Excel 2003..

Is there a way?