Printing Charts in Excel

[Guest]

I need help printing multiple charts in one spreadsheet. The charts are
large, and need to be the entire page on 11 x 17. If I have a single chart
selected, it will print correctly--but if I try to print the whole page, it
wants to put all the charts on one page. I need each chart to have its own
page.

Thanks

 

[Guest]

It sounds as if you have your charts as embedded objects in the worksheet.
If you move the charts to their own sheet you will be able to print multiple
charts on individual sheets. Right click on a chart and select location and
put the chart on its own sheet.

You can Ctrl + Click on each chart sheet and send them to the printer as
group.