View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
JJ JJ is offline
external usenet poster
 
Posts: 122
Default How to let pivot table chart's format stay after refreshing data.

I am using 2007 to do some pivot table pie charts. I selected a red and blue
based format from DESIGN tool bar, and change blue to green. after I saved
then refreshed data, the blue color comes back. How can I let the green color
stay instead of blue? thanks.