How to make the color change stick in a PivotChart

  • Thread starter Thread starter steveski
  • Start date Start date
S

steveski

I have a PivotChart (bar chart). When I format a data series and chang
the color of the bar, it changes color OK. However, when I refresh th
PivotChart, the color reverts to the default. Can you help
 
I have a PivotChart (bar chart). When I format a data series and change
the color of the bar, it changes color OK. However, when I refresh the
PivotChart, the color reverts to the default. Can you help?
Click to expand...

For the "parent" table, uncheck AutoFormat in Table Options.

HTH,
Andy
 
Thanks, but that didn't work.

I did not mention that this PivotChart has to following code to make it
refresh automatically when I click its tab. Is this causing my problem?
 
Back
Top