How to make the color change stick in a PivotChart

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
 
A

Andy Brown

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
 
S

steveski

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

don't want PivotChart to graph every data point 0
Need help modifying code 0
Excel 2010: How to display PivotChart Report Filter Lables on the graph 2
How to make the color change stick in a PivotChart-II 0
How do I adjust&save the PivotChart format? 2
Preserving PivotChart Formatting 2
Remove title bar and phase bar by default on swimlane 0
cannot change datasource of pivotchart 0

Top