How do I adjust&save the PivotChart format?
 

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?
--
====================
ask and you shall be answered

How do I adjust&save the PivotChart format?
 

Hi Zhi Sheng

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

Regards,
Pedro J.

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?

How do I adjust&save the PivotChart format?
 

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


"Infinitogool" wrote:

Hi Zhi Sheng

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

Regards,
Pedro J.

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?