How to set plot area back to automatic?

K

KeepItSimple

Hi,
how do I set the chart plot area back to automatic, and make it stay there?
While opening new workbook and making a chart, the plot area is set to some
colour and I prefer it to keep automatic, and white. How?
 
T

Test

KeepItSimple said:
Hi,
how do I set the chart plot area back to automatic, and make it stay
there?
While opening new workbook and making a chart, the plot area is set to
some
colour and I prefer it to keep automatic, and white. How?

Select the chart, choose Layout, Plot Area or Chart Wall, select More ..
Options and change the Fill option to Automatic.
 
K

KeepItSimple

Hi,
and thanks for advice Test. Forgot to mention that I am using Excel 2003.
I do not get selection of "More". 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 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

Top