How do I save pivotchart colors and shapes on data refresh?

R

ReggieSLC

I have created some nice pivotchart bar charts from a pivot table, but want
to change the color and the shape of some of the data series. I am able to
change them, but they go back to the defaults when I refresh the data. How
can I get the changes to save so that only the data changes when I refresh?
 

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

How do I adjust&save the PivotChart format? 2
Can't save my Office documents (after computer rebuild and reauthorization) 0
Refresh PivotChart subform 3
don't want PivotChart to graph every data point 0
PivotChart disassociation from PivotTable 0
Visio 2013: how do I auto-colour Shapes in alignment with pre-entered Shape Data? 0
Remove title bar and phase bar by default on swimlane 0
Access 2003 PivotChart loses settings 0

Top