How to set new default for plot area settings

K

KeepItSimple

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set plot area back to automatic? 2
Repeating gradient for each vertical area of plot area 3
Excel2007 -- Precisely set plot area size? 3
multiple colors on format of plot area 1
Seemingly random plot area drift? 2
Increase plot size within Chart area 3
Excel Chart Plot Area Auto Size 4
controlling plot area 1

Top