Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default Why plot area does not expand after clearing series legend?

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.

  #2   Report Post  
Echo S
 
Posts: n/a
Default

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.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

wrote in message
ups.com...
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.



  #3   Report Post  
 
Posts: n/a
Default

Echo S wrote:
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.

  #4   Report Post  
 
Posts: n/a
Default

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


Forgot to say thanks. Thanks!

  #5   Report Post  
Echo S
 
Posts: n/a
Default

wrote in message
oups.com...
Echo S wrote:
Just select the plot area with your mouse and drag the edge
to fit the chart area.


Forgot to say thanks. Thanks!


You're very welcome. Weird days'll do that to you. :-)

--
Echo [MS PPT MVP]
http://www.echosvoice.com




  #6   Report Post  
Jon Peltier
 
Posts: n/a
Default

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/
_______

Echo S wrote:

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.


  #7   Report Post  
 
Posts: n/a
Default

Jon Peltier wrote:
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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Plot Area V Rocks Charts and Charting in Excel 2 June 9th 05 05:48 PM
How do I alter plot area colour in a chart without a mouse? debbiecatal Charts and Charting in Excel 2 May 30th 05 04:11 AM
How do I change the excel chart default plot area color? gg96555 Charts and Charting in Excel 2 February 8th 05 07:36 PM
Bar Chart Label Sizes [email protected] Charts and Charting in Excel 2 December 27th 04 03:19 PM
Fill area beneath a scatter plot JZip Charts and Charting in Excel 4 December 8th 04 01:59 PM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"