[SOLVED] 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

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

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
>