POWERTIPS

Extending the Limits of Knowledge

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.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>