how to prevent Excel from reformatting a chart wen updating data?

[Cmd_Marco]

I have data over time for different categories. when i change de reporting
time frame i want the chart colors to stay the same. Or when i change the
scope in categories i still want the categorie chart to keep its color.
How to stop excel from reformatting the colors?

[Andy Pope]

Hi,

I am assuming you are referring to Pivot charts in which case this is a
know problem. If it's not a pivot chart then post back.

Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Cmd_Marco wrote:
> I have data over time for different categories. when i change de reporting
> time frame i want the chart colors to stay the same. Or when i change the
> scope in categories i still want the categorie chart to keep its color.
> How to stop excel from reformatting the colors?

--

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

[Cmd_Marco]

Thx,
But i was referring to normal charts.
I know it's not possible in Pivots.

Marco

"Andy Pope" wrote:

> Hi,
>
> I am assuming you are referring to Pivot charts in which case this is a
> know problem. If it's not a pivot chart then post back.
>
> Changing a PivotChart removes series formatting in Excel
> http://support.microsoft.com/default...;EN-US;Q215904
>
> Cheers
> Andy
>
> Cmd_Marco wrote:
> > I have data over time for different categories. when i change de reporting
> > time frame i want the chart colors to stay the same. Or when i change the
> > scope in categories i still want the categorie chart to keep its color.
> > How to stop excel from reformatting the colors?
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>

[Andy Pope]

How are you changing the chart data then?

I haven't experienced the chart changing or losing it's formatting just
be adjusting the size on data it references.

Cheers
Andy

Cmd_Marco wrote:
> Thx,
> But i was referring to normal charts.
> I know it's not possible in Pivots.
>
> Marco
>
> "Andy Pope" wrote:
>
>
>>Hi,
>>
>>I am assuming you are referring to Pivot charts in which case this is a
>>know problem. If it's not a pivot chart then post back.
>>
>>Changing a PivotChart removes series formatting in Excel
>>http://support.microsoft.com/default...;EN-US;Q215904
>>
>>Cheers
>>Andy
>>
>>Cmd_Marco wrote:
>>
>>>I have data over time for different categories. when i change de reporting
>>>time frame i want the chart colors to stay the same. Or when i change the
>>>scope in categories i still want the categorie chart to keep its color.
>>>How to stop excel from reformatting the colors?
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>>

--

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