How do I adjust&save the PivotChart format?

[Zhi Sheng]

I can adjust my PivotChart format (like background color, line color, scale
etc) in the current view. Once I change the layout or refresh the chart, the
format will revert to the default one.
Is there a way that I can customize the PivotChart format and save it for
future use?

 

[Infinitogool]

Hi Zhi Sheng

See if the article at
http://www.contextures.com/xlfaqPivot.html#FormatLost
does what you want.

Regards,
Pedro J.

 

[Zhi Sheng]

Hi Infinitogool,

Thanks the article does contain a way to get around the problem, though not
a real solution.
Has 2007 fixed this problem?

Regards
====================
ask and you shall be answered