View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
keepitsimple keepitsimple is offline
external usenet poster
 
Posts: 4
Default How to set new default for plot area settings

Hi,
In Excel 2003, how do I set new default value for plot area to Automatic?
Now the default is custom, and background colour one that I do not want.
I can change the plot area to automatic for a chart I have created, but
would like to change the default value so, that whenever creating a new
chart, it would have Plot area settings "Border" and "Area" set as automatic.
Obviously it should be done within the template Book.xlt, but how?