Placing multiple charts on an Excel chart sheet
Posted by ADMIN on February 7, 2007
To place several charts on an Excel chart sheet:
1. Click an empty cell, and press F11.
2. Change the default chart name to ChartSheet2.
3. Select the first chart you want to move to the chart sheet, and go to Chart / Location.
4. Select As Object In, and choose ; from the drop-down list.
5. Click OK.
6. Repeat Steps 3 through 5 for the other charts you want to move.