Forum Discussion

_jon_'s avatar
_jon_
Copper Contributor
Jun 07, 2019
Solved

Chart sheet default paper size

Hi,   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 siz...
excel
  • Zack Barresse's avatar
    Zack Barresse
    Jun 10, 2019

    _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.

Zack Barresse's avatar
Zack Barresse
Iron Contributor
Jun 07, 2019

_jon_ hello there. There is no way to change this by default. IIRC this is tied to your regional [OS] settings. You can circumvent this with code.

 

  1. Press ALT+F11 to open the Visual Basic Editor (VBE)
    1. Alternatively you can click on the Developer tab (must be showing) and click 'Visual Basic'
  2. Show Project Explorer (CTRL+R)
  3. Expand your file/project
  4. Expand 'Microsoft Excel Objects'
  5. Double click on 'ThisWorkbook'
  6. Paste the below code
  7. Close code window

Private Sub Workbook_NewChart(ByVal Ch As Chart)
    If Ch.Type = 3 And Ch.Parent.Name = ThisWorkbook.Name Then
        Ch.PageSetup.PaperSize = xlPaperLegal
    End If
End Sub

Resources