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.
|