Hi,
On a chart sheet, you may put many charts. Let's imagine you have two charts on two distinct worksheets that you wish to combine into one chart sheet for printing and comparing.
Take the following steps:
Press [F11] after clicking an empty cell.
Two Chart Sheet becomes the default chart name.
Go to Chart | Location and choose the first chart you wish to transfer to the chart sheet.
Choose Two Chart Sheet from the drop-down box and choose As Object In.
Click the OK button.
Steps 3 through 5 should be repeated for the second chart you want to relocate.
You may, however, move as many charts as you like. To scale the charts, go to View | Sized With Window.