resize a graph or chart based on paper size w/o macros?

[spacecaptainsuperguy]

I've got a large spreadsheet that has a tab I keep graphs on...usually 3 or 4 graphs per printed page. One manager I send the spreadsheet to can only print up to legal size paper (8.5x14), the other prints on ledger size (11x17). If I format my graphs to fit on a legal size page, then it leaves a lot of blank space when I change my custom views to Ledger size for the other manager. I'm sure I can do something with macros, but was looking for something without if possible. I've used the page break preview to set my page breaks in the right places based on the legal size. Any ideas on how to automatically have the graphs fill up the designated page size as well when printing?

Appreciate any ideas.