[Solved] Is there a way to flip the data?

[DapsyD]

Hi,

For a presentation I have to create a graph showing the share prices of a company over the last 3 months. I download the data as a spreadsheet from yahoo finance and open it using calc. However the only problem is that the most recent share price is at the top with the oldest at the bottom. Subsequently, when I create the graph, it is the wrong way round, with the most recent date on the left and the oldest share price on the right. I was wondering if there is a way to flip the data in the spreadsheet or a way to flip it in the chart creation process. Hope I worded that alright.

Thanks,

Dan

[bobban]

Yes. If for example you have column A with a bunch of dates which are in descending order (and you want ascending), and then your share prices are in column B, then simply select the entire range (all data in A and B column):

Data->Sort..

Column A (ascending) should do the trick.

[DapsyD]

Thanks for the quick reply.

That looks a lot more like the recession now

[TheGurkha]

If this has answered your question please go to your first post and use the Edit button, and add [Solved] to the start of the title. You can also use the green tick icon.

[acknak]

There is also a "Reverse Direction" option for the chart axes. Look on the "Scale" tab for the axis.