plotarea restore automatic sizing


Werner News


the plotarea of a new chart is getting smaller, when a Title, legend or
axis labels is added. When removing these items, the plotarea is
automatically widen to the former size. But if the size of the plotarea
was changed manually, the automatic sizing doesn't work any more.

Is it possible to restore the automatic sizing of the plotarea?
What VBA property contains the information, if the automatic sizing is
working or not?




Jon Peltier

I think the only way to restore this behavior is to reapply the default
formatting of the chart. In 2003, select the chart, go to Chart menu > Chart
Type, and check the Default Formatting box under Options.

- Jon

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