software

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?

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
support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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

Marco

quot;Andy Popequot; wrote:

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

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info