VBA Scale or Resize Chart for Printing Only

[bs0d]

I'm curious if anyone has experimented with this before?

I'd like to print a chart, and force it to scale to match the printer page size for printing purposes only (not modify the chart as it appears in the sheet).

Rationale - The chart fits a design "as-is" in the workbook. But the chart doesn't fill the page when printing, even when specifying to "fit to page".

Thoughts?

 

[bs0d]

I was thinking that one approach could be:

 set the standard size in a variable (x, y).
Then identify what the size will need to be for desired printing out put.
Create a "print" command button tied to a macro that will re-size the chart --> print straight to default printer --> return chart to original size.

This may not be an ideal approach. I'm not sure if you can bypass the print dialog; I think having a print dialog box could cause problems (for instance, if someone canceled the print, would it cancel the rest of the code execution?).

Still open to ideas here. Of course, the goal is something fast, efficient, and least amout