View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ReggieSLC ReggieSLC is offline
external usenet poster
 
Posts: 1
Default How do I save pivotchart colors and shapes on data refresh?

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?