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.