horizontal bar chart print settings messed up when all sheets selected

In my office, we recently updated to Excel 2002. In a
spreadsheet I have updated monthly for over a year, there
are multiple sheets containing horizontal bar charts.

With Excel 2002, when I select an individual sheet and
perform print preview or print it, everything works fine.
When I select all sheets, the charts are compressing into
a blob at the top of the page. In Print Preview, all I
have to do is click on page setup and OK and the format
returns to normal. Or, by paging through the print
preview and then using Previous to go back through each
sheet, the formats return to normal. However, once I
print the file or save it with all sheets selected, the
error occurs again. Please help.