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

  • Can you share some sample data ? it'll be easier for us try to help you, thanks :) – pjmg Apr 28 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
| improve this answer | |
  • 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. – Richard Millington Apr 29 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 at 8:11
  • Ok, so what do I need to do to fix it? It's just text data at the moment :-) – Richard Millington Apr 29 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/… – Richard Millington Apr 29 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 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.