Thanks for your question
Click an empty cell, and press [F11].
Change the default chart name to Two Chart Sheet.
Select the first chart you want to move to the chart sheet, and go to Chart. | ...
Select As Object In, and choose Two Chart Sheet from the drop-down list.
Repeat Steps 3 through 5 for the second chart you want to move.
instead of selecting a chart, select the range of cells containing the
charts you want to print, or
- select one chart, then hold down the Ctrl key while you select the others
that you want to plot.
Since Excel still defines a rectangular print range if you use the second
the method, you might find that some charts print that you did not select.
However, by re-arranging them and/or playing around a bit (with scaling, page
breaks, etc.), you should be able to get what you want.