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

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?
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top