[Solved] X-axis labels in middle of chart

Discuss the spreadsheet application
Post Reply
pedalmegone
Posts: 9
Joined: Mon Oct 07, 2013 12:18 pm

[Solved] X-axis labels in middle of chart

Post by pedalmegone »

Hi, I have x-axis labels appearing in the middle of the chart and I want to move them to the bottom. Y-axis are percentages from -.05 to + .05, etc. The label displays at the '0' level. X-axis are dates, y-axis are percent change. Can anyone tell me how to move these labels?
Open Office 4.1.2; Max OS X El Capitan, 10.11.6.

Thanks in advance!
Last edited by Hagar Delest on Sun Feb 18, 2018 1:44 pm, edited 1 time in total.
Reason: tagged [Solved].
Mac Os X El Capitan 10.11.6
User avatar
Zizi64
Volunteer
Posts: 11360
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: x-axis labels in middle of chart

Post by Zizi64 »

Double click on the X axis; Positioning, Value: -0.5

And then you must set the scale of the Y axis to manual end-values: -0.5 ... +0.5

Tried in AOO 4.1.6 portable.
Axis.ods
(14.89 KiB) Downloaded 62 times
Last edited by Zizi64 on Fri Feb 16, 2018 7:53 pm, edited 1 time in total.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
keme
Volunteer
Posts: 3704
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: x-axis labels in middle of chart

Post by keme »

Double click the chart so you change to "chart edit mode" (shown by tiny black handles around the edge instead of the larger colored ones).
  • Right click the X axis and select Format axis...
  • Select the Positioning tab
  • Select one of the "outside" options for label placement.
Almost the same as Zizi64. His approach allows for more precise placement. Mine is better with automatic rescaling when Y values change.
pedalmegone
Posts: 9
Joined: Mon Oct 07, 2013 12:18 pm

Re: x-axis labels in middle of chart

Post by pedalmegone »

Thank you both for the help! I was able to bring the x-axis labels well below the 0.0 value although it is still a bit above the bottom grid line. However, this is enough! I did use a value well below the scale in following Zizi64.
Mac Os X El Capitan 10.11.6
Post Reply