Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 07, 01:40 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 5
Default Increase plot size within Chart area

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.

  #2   Report Post  
Old December 12th 07, 02:08 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Increase plot size within Chart area

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
_______


"Ropesend" wrote in message
...
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.



  #3   Report Post  
Old December 12th 07, 03:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 5
Default Increase plot size within Chart area

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.

"Jon Peltier" wrote:

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
_______


"Ropesend" wrote in message
...
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.




  #4   Report Post  
Old December 13th 07, 03:07 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Increase plot size within Chart area

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
_______


"Ropesend" wrote in message
...
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.

"Jon Peltier" wrote:

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
_______


"Ropesend" wrote in message
...
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.








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
Excel Chart Plot Area Auto Size jack Charts and Charting in Excel 4 August 28th 07 01:53 AM
Size of plot area expands when Chart Title is deleted - why? Chuck M Charts and Charting in Excel 2 June 22nd 07 01:05 PM
How to change plot area size of pivot chart juamig Charts and Charting in Excel 3 May 11th 06 12:16 PM
How to increase chart area without affecting plot area? [email protected] Charts and Charting in Excel 2 April 21st 06 09:05 PM
How do I increase the plot area over a number of pages? richa Charts and Charting in Excel 1 February 20th 05 02:10 PM


All times are GMT +1. The time now is 09:26 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017