2007 pivot chart formatting
 

I have multiple pivot tables and multiple charts associated on one worksheet.
While viewing the sheet in Page Layout View excel shows the charts and the
tables exactly the way i want. I have the "set print area" 1 page wide by 1
page long, the margins set, etc. However, when i go to Print Preview and/or
Print the doc, it shows the chart resized (to its orginial size). I want to
anchor the size of the chart to the size that i make on the sheet in Page
Layout View. thanks for any of your help