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?

How to set new default for plot area settings
 

Hi,

You can format a chart and store it as a user defined chart type, which can
also be set as the default.
http://pubs.logicalexpressions.com/P...cle.asp?ID=299


Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"KeepItSimple" wrote in message
...
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?