printing all charts in the workbook

T

Tony

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

Top