I presume the "holding window" is how you describe the ChartObject, i.e.,
the shape containing the embedded chart. Drag the handles on the shape while
holding the Alt key to make the shape snap to the cell boundaries.

To resize the plot within the shape, select the plot area, the rectangle
defined by the chart axes. resize this plot area as needed to reduce the
unused space around the plot.

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


"clark-ee" wrote in message
...
I have a graph that I would like to fit onto one page, overlayed on an
excel
spreedsheet. The problem is, when I make the holding window fit, the
graph
itself won't enlage enough, and when I make the holding window larger, it
effects the page size and placement.

I have notice that to the right of the graph, there is a large space
(where
the label default is) that is empty, and I can't figure out how to make
that
space usable.