Graphs

[Conditional Formatting]

I have a pivot table. Every period I refresh the data. The grpahs that I
created change every time I refresh. So I have to do the format of the graph
all over again. Is there a way to prevent this.

Thanks.

[Debra Dalgleish]

Unfortunately, loss of formatting is a known problem with pivot charts.
There's information in the following MSKB article, which suggests
recording a macro as you apply the formatting:

Changing a PivotChart Removes Series Formatting in Excel
http://support.microsoft.com/?id=215904

Conditional Formatting wrote:
> I have a pivot table. Every period I refresh the data. The grpahs that I
> created change every time I refresh. So I have to do the format of the graph
> all over again. Is there a way to prevent this.
>
> Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html