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.

To get your chart to fill the entire page in Excel 2007, you can follow these steps:

1. Click on the chart to select it.
2. Go to the "Page Layout" tab in the ribbon.
3. Click on the "Print Area" dropdown and select "Set Print Area".
4. Go to the "Size" dropdown and select "More Paper Sizes".
5. In the "Page Setup" dialog box, select the "Page" tab.
6. Under "Scaling", select "Fit to:" and set both the "Width" and "Height" to "1 page".
7. Click "OK" to close the dialog box.
8. Go back to the "Page Layout" tab and click on the "Print Titles" dropdown.
9. In the "Page Setup" dialog box, select the "Sheet" tab.
10. Under "Print Titles", click on the "Rows to repeat at top" field and select the row(s) that contain your chart title and axis labels.
11. Click "OK" to close the dialog box.

Your chart should now fill the entire page when you print it. If there are still gaps between the chart and the top/bottom margins, you may need to adjust the margins or the size of the chart.

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.

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.

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.

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.