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

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.

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

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

"JJ" wrote:

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.

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

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
_______



"Shane Devenshire" wrote in
message ...
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

"JJ" wrote:

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.