If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|