1

I'm (unfortunately) stuck on my phone without access to a laptop most day, so when I'm messing around in Google Sheets, my scatter plots end up awfully stretched/squashed:

two ellipses drawn using a scatter plot. The x-axis is stretched and the y-axis is squashed so the grid lines are not square

As you can see the grid lines are not square.

I've edited that screenshot to demonstrate what I'm sort of after:

the same scatter plot as above but image edited to make the gridlines square

I can open the sheet in a browser from my phone (this doesn't fix the squashing/stretching) so I have access to the additional chart editing options there.

How can I fix the two axes to be a more 1:1 ratio?

1 Answer 1

3

As far as I can tell, if you create a chart and move it to its own worksheet then you have no control over the overall shape of the chart as it is completely dictated by the w:h ratio of the window Sheets is running in (or in the case of a phone, the w:h ratio of the full screen). In order to control a chart's dimensions you need to make it within a normal worksheet. There is a 'Resize Charts' add-on which allows you to specify the exact dimensions in pixels, otherwise it's a case of using the mouse to drag the corners and eyeballing the result.

2
  • Ahhh, damn. Any idea how to move the chart into a work book? Dec 19, 2023 at 9:04
  • Go to the worksheet the chart is in, then select 'Copy sheet' at the top of the screen, then change worksheet, click on any cell and then Ctrl+V to paste another instance of the chart at that location. Dec 19, 2023 at 11:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.