View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default Changing pivot chart format


"..........change the defaults in the color palette, which changes the
defaults for everything."


I may use the macro method but curious about changing the color pallete
method. I am adding two columns per month so I would have to re-record
the macro each time if I use the maco method.

How would I go about changing the defaults in the color palete?


Thanx