Excel - Increase plot size within Chart area

Asked By Ropesen

12-Dec-07 07:40 AM

Help, report due today.  How do I increase the size of the plot area to fit
more closer to the chart area margins.  I would like to bring the plot area
closer to the border of the chart area.  This has been annoying me.  Moving
the chart handles to increase the size simply moves the white border with it.
Assistance that works, greatly appreciated.

12-Dec-07 08:08 AM

Click in the middle of the chart to select the Plot Area. Resize this
rectangle to suit. If it's a 3D chart, you will not be able to make it as
large as you'd probably like.

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

12-Dec-07 09:37 AM

I do have a 3-D chart.  I am looking to expand it horitonally.  I've tried
the plot area handle bar drag. This is not working--neither in chart as
separate sheet or on a chart sheet.  I would like to stretch the plot area to
take up the empty spaces on both sides.  How do I do this? This will help me
with the flat charts also.  Thanks
at my ropes end.

13-Dec-07 09:07 AM

If you try the protocol I've described, and it doesn't work, then you have
stretched the plot area as far as it will go. Using a better chart type
might help (3D charts have innumerable problems, not just mechanically, but
cognitively as well).

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