Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Crop white space on chart

6,089 views
Skip to first unread message

femfrog

unread,
Nov 10, 2007, 12:34:00 PM11/10/07
to
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....

Jon Peltier

unread,
Nov 11, 2007, 12:08:49 PM11/11/07
to
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" <fem...@discussions.microsoft.com> wrote in message
news:C01C7EA8-15D1-4E74...@microsoft.com...

Susie

unread,
Nov 23, 2007, 8:33:43 AM11/23/07
to
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

Jeanne Miner

unread,
Dec 6, 2010, 1:30:54 PM12/6/10
to
Brilliant, Jon. Extend the axis-defined-rectangle outwards, then resize the whole chart back where you want it.

> On Saturday, November 10, 2007 12:34 PM femfro wrote:

> 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....


>> On Sunday, November 11, 2007 12:08 PM Jon Peltier wrote:

>> 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" <fem...@discussions.microsoft.com> wrote in message
>> news:C01C7EA8-15D1-4E74...@microsoft.com...


>> Submitted via EggHeadCafe
>> Microsoft ASP.NET For Beginners
>> http://www.eggheadcafe.com/training-topic-area/ASP-NET/7/ASP.aspx

0 new messages