Apache OpenOffice Community Forum

I have a table with dates in column one, and prices in column 2. The date column starts with the latest date at the top to the oldest at the bottom. I have made a line chart which displays this data.

But I want the chart line to go the other way round. So the beginning of the chart (left) should be the oldest date, and the end (right) should be latest date. I don't want to change the date column to be oldest first because I prefer the newest date at the top (for reading without scrolling down).

Any way to flip the chart around?

See:

http://www.oooninja.com/2008/02/reverse ... graph.html

Right Click on your chart, go to Edit. The chart is editable now.
Then right click on the axis you want to change and go to "Format Axis".
Click on the Scale tab and check the box next to Reverse direction.

Brilliant, both methods work! However after reversing, the Y axis (date) has shifted over to the right side of the chart. Can I make it stay on the left like a normal chart?

Brilliant, both methods work! However after reversing, the Y axis (date) has shifted over to the right side of the chart. Can I make it stay on the left like a normal chart?

Double click the the chart (to make it editable)
Then right click on it and select insert/delete axes..
under Axes: uncheck the Y axis
under secondary axes check Y axis

Perfect! Just when I thought Calc was missing all the features I used in Excel. Thanks!