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?
[Solved] Make chart display backwards?
[Solved] Make chart display backwards?
Last edited by Hagar Delest on Sun Jun 13, 2010 9:28 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
- Robert Tucker
- Volunteer
- Posts: 1250
- Joined: Mon Oct 08, 2007 1:34 am
- Location: Manchester UK
Re: Make chart display backwards?
LibreOffice 7.x.x on Arch and Fedora.
-
- Posts: 48
- Joined: Mon May 31, 2010 9:47 pm
Re: Make chart display backwards?
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.
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
Re: Make chart display backwards?
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?
-
- Posts: 48
- Joined: Mon May 31, 2010 9:47 pm
Re: Make chart display backwards?
Double click the the chart (to make it editable)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?
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
Re: Make chart display backwards?
Perfect! Just when I thought Calc was missing all the features I used in Excel. Thanks!