printing all charts in the workbook

G

Guest

I have workbook with charts on two worksheets. I need to create PDF file with
each chart on separate page. At present I am printing two sheets and I am
dividing charts in Acrobat. Is it possible to generate one file with each
chart from both sheets to appear on separate pages ?

Thanks for help.

Tony
 
N

NickHK

You can set the WS.PrintArea to the 2 areas covered by your charts, then
they will each print on separate pages.

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why do charts disappear? 2
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
deselect any "active" charts in workbook 2
Copy charts and remove links to original source data 12
paste 2 charts on the same image on a userform 2
Print problems w/ charts excel 2003/2007 3
Copy Charts from Excel worksheet to PowerPoint 3
How do I modify charts thorugh VB 9

Top