When you create a line plot chart out of a column in Google Spreadsheet, it has its Y-axis marked with values from the data range, but its X-axis completely unmarked, which makes zero sense: Note the absense of X-axis labels

Note the absense of X-axis labels

How do I make Google Spreadsheet auto-number values in the column and present number in series, starting from 1, as X-axis marking?

That's what LibreOffice and Excel do by default: Note the presense of X-axis labels

Note the presense of X-axis labels

I understand that I can have additional column with labels for X-axis but that's extra work that obviously should be done by spreadsheet (as Excel and LibreOffice do) so I expect some checkbox somewhere that I didn't see.

closed as off-topic by slhck, Keltari, fixer1234, n8te, Kamil Maciorowski Nov 25 '17 at 17:26

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "This question is not about computer hardware or software, within the scope defined in the help center." – slhck, Keltari, fixer1234, n8te, Kamil Maciorowski
If this question can be reworded to fit the rules in the help center, please edit the question.


You can try and create your own values for X like this.


This will create a 1 - 26 values in the row where you will place the formula.

Hope that will help you.

  • I don't understand where I should put this formula to. Can you elaborate? – alamar Nov 22 '17 at 14:53
  • For example put this formula in A1 and you will have numbers go for every collumn, then you can do it as X for your needs if needed to be used in another formulas – user1448914 Nov 22 '17 at 14:55
  • Still it requires additional setup and isn't easier than just adding an index row manually. – alamar Nov 22 '17 at 15:20

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