Use series number as X axis label in Google Spreadsheet

Question

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

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

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.

Answer 1

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

=ARRAYFORMULA(COLUMN(A:Z))

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

Hope that will help you.