Posts by johndrew98

So I don't forget and perhaps help others. Here is what I did: At the bottom of the graph: Select/click on the X axis footer. Select format Axis, then at the right near the bottom is (Categories in Reverse Order). The data comes in with the most recent first and I wanted the chart to read oldest to most current. The reverse order function did it.

Yes, Got It worked Thanks

I reversed and copied the numbers from A33 up to A2, inserted a Graph and it is the same as if I copy from A2 down. Perhaps I did something wrong. I clicked on the graph and did an edit on data formula and changed the range as it should be and got the same answer.

I am making a Graph and the data coming in is the most current starting in A2...A 31 I am making a graph but would like the most current to be at the last in the graph so it reads from the left to the right. I just need to reverse the data making the oldest to be in A2.. I looked at Transpose but does not do that function.