Printing to PDF

[nickfinity]

I've got a macro that loops through the charts on a sheet and exports them to jpg. That works, but for my purposes jpg quality probably won't cut it. So I've set it up to print to PDF. I've got it working so I have one chart on a page. That's what I want, but the issue is that the chart only takes up maybe half the size of the page. I'd like to fit the page size to the size of the chart. Is there a way to do this?

Thanks for any help, I sincerely appreciate it.

Nick

 

[dannac]

Look at

File - Page Setup - Scaling

 

[nickfinity]

Thanks for the help. I should have specified, but I'm using Excel 2007. I found the scaling option, but does that work when I'm trying to print just the chart? If I could use scaling would there be a way to automatically figure out what it should be to fit one page?

Thanks,
Nick