Author Topic: Cannot resize MELTS for Excel graphs (including Combine tbl)  (Read 96 times)

Paula

  • Administrator
  • Hero Member
  • *****
  • Posts: 411
    • View Profile
    • My GPS Division profile
This can occur for regular MELTS for Excel runs, or for the Combine tbl function on Windows. I don't know of it happening for Combine tbl on Mac (and I don't have a good way to test if it while working from home)...

The problem: A graph generated by MELTS for Excel is tiny, and dragging on the corners does not resize it. Zooming in increases text size but does not fix the graph layout.

The solution: Go to File->Print and choose a different printer e.g. the built-in "Microsoft Print to PDF" or any with a normal US letter or A4 page size. It turns out that Excel defaults to the page layout of the last connected printer. For my Windows laptop that's a label maker, so the page is half an inch tall!

Fore more details, see: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_o365b/unable-to-resize-chart-in-ms-excel-in-separate/7066bce9-9b50-404c-b3d5-707a341c55b4

Paula