For info, not only the sort order but the gridline appearance is based on the final series (not the first series)
There is a popup message that tells you this but its easy to miss:
Whilst you can enter values for other series, they will normally be overwritten
In this case, I have the x-axis...