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.