Graphs

  • Thread starter Conditional Formatting
  • Start date
C

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.
 
D

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
 
Top