Pivot table chart - turn off automatic color
 

Hi All,
I have a chart that contains several input created through a pivot table.
For making my chart clear I decided to apply 3 colors for my inputs some are
green, some are yellow and some are red.
But after each refresh, I get the default colors coming back.
How can I remove this default color setting and save my color choice ?
thanks for your replys
Denis

Pivot table chart - turn off automatic color
 

Hi,

Loss of chart formating on refresh is a know bug.
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Denis Le Bellego wrote:
Hi All,
I have a chart that contains several input created through a pivot table.
For making my chart clear I decided to apply 3 colors for my inputs some are
green, some are yellow and some are red.
But after each refresh, I get the default colors coming back.
How can I remove this default color setting and save my color choice ?
thanks for your replys
Denis

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Pivot table chart - turn off automatic color
 

thanks a lot for your help
denis

"Andy Pope" wrote:

Hi,

Loss of chart formating on refresh is a know bug.
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Denis Le Bellego wrote:
Hi All,
I have a chart that contains several input created through a pivot table.
For making my chart clear I decided to apply 3 colors for my inputs some are
green, some are yellow and some are red.
But after each refresh, I get the default colors coming back.
How can I remove this default color setting and save my color choice ?
thanks for your replys
Denis

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info