View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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.