2

Really simple question that's driving me nuts for a while. How do I get my line graph in Google Sheets to begin at the Y axis - i.e. so there isn't a gap before the January 2020 date?

I've been looking for a while and can't find the answer.

enter image description here

UpdateHere's a sample of the data:

enter image description here

1
  • Can you share some sample data ? it'll be easier for us try to help you, thanks :)
    – pjmg
    Apr 28 '20 at 23:00
0

There's a good chance the data in the horizontal axis are not well formated, especially when it comes to dates.

  1. If datas inside the horizontal axis are texts (ex : 'Feb 2020 instead of Feb 2020)
    -> try to check Maximise inside the chart editor enter image description here

  2. If the datas are the date type of format

    • You can try to refactor theses dates with the first day of each month (with something like =eomonth(startdate , 1)-1
    • Or check the number of gridlines for the horizontal axis. enter image description here
9
  • Thanks for this. I've updated with a sample of the data. I couldn't get either of the solutions above to work. The maximise still left the gap. There was no horizontal gridline option. Not sure exactly how to use the eomonth code. I suspect the problem is these are just text dates. But It has to show only the month and not the first of the month - as that would be misleading. Apr 29 '20 at 7:28
  • 1
    It only show the month (Jan 2020), but as Sheet recognize it as a a date it's a specific day like 01/01/2020 if you check the cell. In other words, it may display Jan 2020, but the cell value is a number like 4860 with a date format.
    – pjmg
    Apr 29 '20 at 8:11
  • Ok, so what do I need to do to fix it? It's just text data at the moment :-) Apr 29 '20 at 11:07
  • I tried changing the formatting to dates, but now it's adding the same month in their twice - which makes no real sense: dropbox.com/s/oenp9gpjb1u2cl9/… Apr 29 '20 at 11:12
  • Be sure to have some coherent ratios between starting vs ending date and add as much gridlines as you need. Can you share some sample data ? (or a copy of the sheet, can't do much with screenshots)
    – pjmg
    Apr 29 '20 at 15:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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