Pivot Chart Formatting

[Germeny Santos]

How can I format a Pivot Chart and keep the customized format when refreshed?

 

[Luke M]

This is a known issue by Microsoft.
Short answer, you can't do it. =(

One possible work around is to record a macro of you setting the formatting
of the chart, and then set it up so that the macro runs whenever the chart
calculates.

 

[Shane Devenshire]

Hi,

This is dependent on what custom formatting you are refering to. There are
work arounds for some of the problems.

One work around is to purchase 2007, this problem has been fixed in most
areas, however there are still workarounds for 2003.

As mentioned you can record a macro which does your custom formatting and
then run it from the

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

End Sub

event macro.

If this helps please click the Yes button.

Cheers,
Shane Devenshire