Keep Pivot Table Chart Format unchanged

[Nir]

I want to keep changes to format i performed in a pivot chart, that would not
be affected upon refresh table.

thanks\

 

[Andy Pope]

This is a known bug that requires vba code to re-apply formatting.

XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904

Cheers
Andy

 

[Nir]

thanks Andy,
does MS supply any add-in for or just record it on my local report?
thanks

 

[Andy Pope]

Use the macro recorder to capture the formatting commands.

Here is a great resource for all things pivot tablely!
http://www.contextures.com/xlfaqPivot.html

Cheers
Andy