Why plot area does not expand after clearing series legend?

J

joeu2004

Normally, when I create a chart and clear the series
legend, the plot area expands to the right to fill the
space.

This time, it does not.

How can I get the plot area to fill the chart area?

I have tried reinstituting te series legend and clearing
it again, to no avail.

I am using Office Excel 2003 (11.6355.6360) SP1.
 
E

Echo S

Just select the plot area with your mouse and drag the edge to fit the chart
area.

That said, I don't know why it's not resizing on its own.
 
J

joeu2004

Echo said:
Just select the plot area with your mouse and drag the edge to
fit the chart area.

Sure! I never noticed the handles on the plot area before.
Klunk!
That said, I don't know why it's not resizing on its own.

It's been a wierd day.
 
J

Jon Peltier

Once you've manually edited the size of one of a chart's elements, it no longer
resizes interactively when you make other changes. This is why resizing a chart
element can help prevent Excel from changing its size when it's printed or when the
file is later reopened.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
J

joeu2004

Jon said:
Once you've manually edited the size of one of a chart's elements,
it no longer resizes interactively when you make other changes.

Makes sense. I have no recollection of __purposely__ making any
manual changes -- that is, none that I have never done before without
getting the chart into a mode where Excel would not auto-resize the
plot area. But that certainly does not rule an accidental change,
which after all is oh-so easy to do, especially with my laptop.

I was going to ask you how to tell Excel to take back default control
of the object -- at least, resize the plot area automatically again.

But after I made the manual change that "Echo" suggested, the plot
area now tracks the chart area when I change the latter.

Go figure!
 

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