Plot area shrinks and shifts
 

I want to print four pages, which include three separate charts, from the
same worksheet. The worksheet is setup to repeat the three top rows, which is
how I wnat the charts to print with the workheet title above the chart title.
The first sheet is data with three charts following. All four sections, data
and charts, sit between natural page breaks. When I print from the worksheet,
the chart plot areas shrink and shift into the chart title area. Printing the
charts seperately works fine. I have futzed with the margins on both the
worksheet and the individual charts without much luck. I have also changed
chart sizing whit no improvement. To make this more interesting, sometimes
the charts look fine when printing from the worksheet; other times they
shrink and shift. I am using Excel 2003. Thanks

Plot area shrinks and shifts
 

I moved the charts to another worksheet so they can be selected and printed
separately.

"Steve-in-austin" wrote:

I want to print four pages, which include three separate charts, from the
same worksheet. The worksheet is setup to repeat the three top rows, which is
how I wnat the charts to print with the workheet title above the chart title.
The first sheet is data with three charts following. All four sections, data
and charts, sit between natural page breaks. When I print from the worksheet,
the chart plot areas shrink and shift into the chart title area. Printing the
charts seperately works fine. I have futzed with the margins on both the
worksheet and the individual charts without much luck. I have also changed
chart sizing whit no improvement. To make this more interesting, sometimes
the charts look fine when printing from the worksheet; other times they
shrink and shift. I am using Excel 2003. Thanks