[Solved] Make chart display backwards?

Discuss the spreadsheet application
Post Reply
nLinked
Posts: 6
Joined: Sun Apr 20, 2008 10:10 pm

[Solved] Make chart display backwards?

Post by nLinked »

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?
Last edited by Hagar Delest on Sun Jun 13, 2010 9:28 pm, edited 1 time in total.
Reason: tagged [Solved].
User avatar
Robert Tucker
Volunteer
Posts: 1250
Joined: Mon Oct 08, 2007 1:34 am
Location: Manchester UK

Re: Make chart display backwards?

Post by Robert Tucker »

LibreOffice 7.x.x on Arch and Fedora.
aloarjr810
Posts: 48
Joined: Mon May 31, 2010 9:47 pm

Re: Make chart display backwards?

Post by aloarjr810 »

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.
Apache OpenOffice4.1.2, Windows 7
nLinked
Posts: 6
Joined: Sun Apr 20, 2008 10:10 pm

Re: Make chart display backwards?

Post by nLinked »

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?
aloarjr810
Posts: 48
Joined: Mon May 31, 2010 9:47 pm

Re: Make chart display backwards?

Post by aloarjr810 »

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
Apache OpenOffice4.1.2, Windows 7
nLinked
Posts: 6
Joined: Sun Apr 20, 2008 10:10 pm

Re: Make chart display backwards?

Post by nLinked »

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