How to let pivot table chart's format stay after refreshing data.

[JJ]

I am using 2007 to do some pivot table pie charts. I selected a red and blue
based format from DESIGN tool bar, and change blue to green. after I saved
then refreshed data, the blue color comes back. How can I let the green color
stay instead of blue? thanks.

 

[Shane Devenshire]

Hi,

It appears that you are changing the color in the wrong place:

1. With a single slice selected choose PivotChart Tools, Format
2. Click Format Selection
3. Pick the Fill tab
4. Select Solid fill
5. Pick a Color and Close the dialog box.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

 

[Jon Peltier]

Nope. It's a pivot chart. I'm not sure how this works in 2007, I suspect
it's not as sticky. In 2003 you could enforce some colors by changing a few
of the palette colors.

However, I think this fits under the umbrella of Excel reapplying the
default formatting to a pivot chart when the underlying pivot table is
pivoted or refreshed. Even Microsoft acknowledges that this is a problem,
and they recommend recording a macro next time you have to reapply your
custom formatting, then reuse this macro as needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______