Discussion Locked

Excel print multiple worksheets on 1 pag

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to take charts off of several different worksheets in a workbook and print them on one page. We want to have 4 charts per page print. Just curious if anyone has a quick solution for this? Thanks!

3 replies

by dklippert

You can copy the charts and paste them on a new page. You can also use the Camera feature (Tools>Customize choose Tools on the Commands tab and scroll down.)
You can run the Chart wizard (again if necessary) and choose As object in And pick a sheetto place any number of charts.
When you perform the last option, be aware that the charts will stack on top of each other and then will have to be moved around.

This discussion is closed to new replies.