How can I change a Numbers graph x axis to go from the lowest value to the highest value?

I'm graphing columns A and B, where A is the x axis. I have entries entered in A like so: 1, 3, 2, 4, 5... and so on.

When I select A and B and make a graph, it seems like the x axis does not automatically arrange itself from the lowest to the greatest value, meaning the graph looks quite strange.

Is there a way to make the x axis graph the data as 1, 2, 3, 4, 5... instead of as 1, 3, 2, 4, 5...?

Sorry if I am unclear. I will make amendments at the earliest opportunity if clarification is required.

Solution 1:

Sort your data ascending based on the values in column A - the x-axis.