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

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Move Chart with Text 0
Descenders clipped 0
Why do charts disappear? 3
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 13
Shift Collate sheet 1-20 when printing entire workbook? 0
Update Multiple Charts then Print to One PDF File 1
Using custom charts with other computers 0

Top