PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Crop white space on chart

Reply

Crop white space on chart

 
Thread Tools Rate Thread
Old 10-11-2007, 05:34 PM   #1
=?Utf-8?B?ZmVtZnJvZw==?=
Guest
 
Posts: n/a
Default Crop white space on chart


I created a chart and got it the right size so it can fit on the page.
However, there is about four inches of white space that I cannot get rid of.
If I decrease the size of the whole chart area, it changes the size of the
graph, font included. The only method I know how of getting rid of the white
space is increasing the size of my graph but it does not fit on the page
anymore. I DO NOT WANT THIS TO HAPPEN.

Ideally, I would like to "crop" out the white space of the chart area
without affecting the size of my graph.

Please help!!!! This is so frustrating :s

Thanks so much....
  Reply With Quote
Old 11-11-2007, 05:08 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: Crop white space on chart

Select the plot area by clicking inside the inner rectangle which is defined
by the axes, and drag the edges of this outward. This will reduce the white
margins around the chart features.

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


"femfrog" <femfrog@discussions.microsoft.com> wrote in message
news:C01C7EA8-15D1-4E74-89C9-2B413749A841@microsoft.com...
>I created a chart and got it the right size so it can fit on the page.
> However, there is about four inches of white space that I cannot get rid
> of.
> If I decrease the size of the whole chart area, it changes the size of the
> graph, font included. The only method I know how of getting rid of the
> white
> space is increasing the size of my graph but it does not fit on the page
> anymore. I DO NOT WANT THIS TO HAPPEN.
>
> Ideally, I would like to "crop" out the white space of the chart area
> without affecting the size of my graph.
>
> Please help!!!! This is so frustrating :s
>
> Thanks so much....



  Reply With Quote
Old 23-11-2007, 01:33 PM   #3
Susie
Guest
 
Posts: n/a
Default Re: Crop white space on chart

when you paste the chart into word you get your nicely resized chart.
However you still have a large white space to the right of your chart. Do
you know how to get rid of this? Any help would be much appreciated!

url:http://www.ureader.com/msg/10294790.aspx
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off