I have an Excel 2007 workbook file with about 6 worksheets. Each worksheet contains basically EVM reporting information and charts that display SPI and CPI. My issue comes when I print or print preview the worksheet containing the charts. They move slightly from the place that I had them positioned perfectly on the page beneath the summary data.

Not a big deal for some worksheets because they are only 8 pages long. However, on other worksheets that are 20-30pages long containing two charts per page, by the time you get to the last page the charts are way out of the original location that I had placed them.

I’ve tried all of the property settings, tried redoing the print area, tried the size of the charts, tried the updating and service packs…. seems like I’ve tried everything.

This was not an issue in Excel 03. The work around to save back to 03 is not an option now because all of the charts have been redone in 07 so 03 produces the same effect now.

Is there a bug or fix for this issue?

It seems so easy, please help

Thanks!
MikeP