When I select data in an excel 365 worksheet and press F11 to chart it, the chart sheet creates using the 'Letter' paper size... I can manually change the chart sheet to use 'Legal' paper size, but I'd like it to create using 'Legal' by default.
Is there any way to change the default paper size for chart sheets?
Note that when I open a new workbook and click File > Print, the paper size is shown as Legal.
If I understand correctly, I need to create this macro in each new workbook I create, in order for it to be active in that workbook... Do you know any way I can make excel create new workbooks with this macro already present?
@_jon_ you'd have to add the solution to a file, then save it as a template, and open a Workbook from that template every time. It's probably something I'd create a macro for and store it in your Personal.xlsb file, then assign it to a Ribbon/QAT button.
Best Response confirmed by
_jon_ (New Contributor)