how to "lock-in" format of a pivot chart from a pivot table?

  • Thread starter Thread starter Vilok Kusumakar
  • Start date Start date
V

Vilok Kusumakar

i.e. If I have changed format of pivot chart - line chart,
formatting etc.

Then when I refresh the pivot table, chart redraws with
new default formatting. Do you know if there is a way to
lock the formatting?
 
Some formating is reset by XL by design, some is reset because of one
or more bugs. Check the MSKB (support.microsoft.com) for more. But,
the bottom line is that if you use custom formating there is no
guarantee that it will stick across a refresh. The alternative is to
use a VBA macro that does the refresh and then applies the desired
formatting.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top