A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Get 2007 Chart to fill page



 
 
Thread Tools Display Modes
  #1  
Old May 18th, 2010, 04:07 PM posted to microsoft.public.excel.charting
Domenick
external usenet poster
 
Posts: 36
Default Get 2007 Chart to fill page

How do I get Excel 2007 to print a Chart "Full Page?" In previous versions,
you would just click on the chart and hit "Print" and excel would
automatically stretch the chart horizontally and vertically to fill the
entire page. In 2007, my chart fills between the left and right margins, but
there are several inches between both the top and bottom of the page and my
chart. (Even though the page margins for top and bottom are set as low as
they can go.)

What am I missing? Thanks.
Ads
  #2  
Old May 18th, 2010, 05:53 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Get 2007 Chart to fill page

You are missing nothing. Excel 2007 is missing this capability, which
Microsoft removed for some unknown reason.

You would have to manually stretch the chart to fit on a single page.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 5/18/2010 11:07 AM, Domenick wrote:
How do I get Excel 2007 to print a Chart "Full Page?" In previous versions,
you would just click on the chart and hit "Print" and excel would
automatically stretch the chart horizontally and vertically to fill the
entire page. In 2007, my chart fills between the left and right margins, but
there are several inches between both the top and bottom of the page and my
chart. (Even though the page margins for top and bottom are set as low as
they can go.)

What am I missing? Thanks.

  #3  
Old May 20th, 2010, 02:09 PM posted to microsoft.public.excel.charting
AdamV[_2_]
external usenet poster
 
Posts: 38
Default Get 2007 Chart to fill page

This is similar to the issue that if you have a chart in its own sheet
in 2007 and have margins which are particularly large at the top/bottom
or left/right, the chart gets truncated rather than scaled to fit down
into the new ratio. Essentially 2007 chart engine does not seem to want
to stretch or shrink the chart, only "zoom in/out" keeping everything
proportional to the original shape.
This seems to have been fixed in 2010, as you change the margins of a
chart sheet the chart actually resizes to fit the appropriate ratio.
So if an upgrade to 2010 is possible for you, then this could offer a
solution.

Adam

On 18/05/2010 17:53, Jon Peltier wrote:
You are missing nothing. Excel 2007 is missing this capability, which
Microsoft removed for some unknown reason.

You would have to manually stretch the chart to fit on a single page.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 5/18/2010 11:07 AM, Domenick wrote:
How do I get Excel 2007 to print a Chart "Full Page?" In previous
versions,
you would just click on the chart and hit "Print" and excel would
automatically stretch the chart horizontally and vertically to fill the
entire page. In 2007, my chart fills between the left and right
margins, but
there are several inches between both the top and bottom of the page
and my
chart. (Even though the page margins for top and bottom are set as low as
they can go.)

What am I missing? Thanks.

  #4  
Old May 21st, 2010, 04:15 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Get 2007 Chart to fill page

Nope, you can't size the chart to fit the window in 2010. It might be
nicer in the way it fits the chart into the print area, but it still
does not fit the chart to the window.

Too bad, it would have been another nice give-back.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/20/2010 9:09 AM, AdamV wrote:
This is similar to the issue that if you have a chart in its own sheet
in 2007 and have margins which are particularly large at the top/bottom
or left/right, the chart gets truncated rather than scaled to fit down
into the new ratio. Essentially 2007 chart engine does not seem to want
to stretch or shrink the chart, only "zoom in/out" keeping everything
proportional to the original shape.
This seems to have been fixed in 2010, as you change the margins of a
chart sheet the chart actually resizes to fit the appropriate ratio.
So if an upgrade to 2010 is possible for you, then this could offer a
solution.

Adam

On 18/05/2010 17:53, Jon Peltier wrote:
You are missing nothing. Excel 2007 is missing this capability, which
Microsoft removed for some unknown reason.

You would have to manually stretch the chart to fit on a single page.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 5/18/2010 11:07 AM, Domenick wrote:
How do I get Excel 2007 to print a Chart "Full Page?" In previous
versions,
you would just click on the chart and hit "Print" and excel would
automatically stretch the chart horizontally and vertically to fill the
entire page. In 2007, my chart fills between the left and right
margins, but
there are several inches between both the top and bottom of the page
and my
chart. (Even though the page margins for top and bottom are set as
low as
they can go.)

What am I missing? Thanks.

  #5  
Old May 29th, 2010, 12:33 AM posted to microsoft.public.excel.charting
AdamV[_2_]
external usenet poster
 
Posts: 38
Default Get 2007 Chart to fill page

John, I think we may be saying the same thing in different ways.

A chart on it's own sheet in 2010 is sized to fit the ratio of the
printable area of the page (dependent on the margins, of course).
It is then zoomed to fit in the the height of the window (and adjusts if
you extend the formula bar down to take more space, or minimise the
Ribbon). If you change the zoom manually, it keeps the new zoom level
instead of readjusting. To get it to fit the window again, selct the
chart and go to View Zoom to selection.
(if you have really weird margins so that the shape of the chart is
ultra-wide landscape, it does not seem to do as good a job of working
out the right zoom and centralising it.

So you're right, there is no option to change the chart to *fill* the
window, it fills the page area and zooms to fit this shape in the
window. Given the prevalence of on-screen use of Excel for viewing or
presenting information, it would indeed be useful to have an option to
fill the window rather than the page.

On 21/05/2010 04:15, Jon Peltier wrote:
Nope, you can't size the chart to fit the window in 2010. It might be
nicer in the way it fits the chart into the print area, but it still
does not fit the chart to the window.

Too bad, it would have been another nice give-back.

-
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/20/2010 9:09 AM, AdamV wrote:
This is similar to the issue that if you have a chart in its own sheet
in 2007 and have margins which are particularly large at the top/bottom
or left/right, the chart gets truncated rather than scaled to fit down
into the new ratio. Essentially 2007 chart engine does not seem to want
to stretch or shrink the chart, only "zoom in/out" keeping everything
proportional to the original shape.
This seems to have been fixed in 2010, as you change the margins of a
chart sheet the chart actually resizes to fit the appropriate ratio.
So if an upgrade to 2010 is possible for you, then this could offer a
solution.

Adam

On 18/05/2010 17:53, Jon Peltier wrote:
You are missing nothing. Excel 2007 is missing this capability, which
Microsoft removed for some unknown reason.

You would have to manually stretch the chart to fit on a single page.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 5/18/2010 11:07 AM, Domenick wrote:
How do I get Excel 2007 to print a Chart "Full Page?" In previous
versions,
you would just click on the chart and hit "Print" and excel would
automatically stretch the chart horizontally and vertically to fill the
entire page. In 2007, my chart fills between the left and right
margins, but
there are several inches between both the top and bottom of the page
and my
chart. (Even though the page margins for top and bottom are set as
low as
they can go.)

What am I missing? Thanks.

 




Thread Tools
Display Modes

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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:27 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.