[Solved] Adjusting X-axis scale
-
- Posts: 5
- Joined: Sun Apr 27, 2008 7:29 am
[Solved] Adjusting X-axis scale
Any suggestions for how to adjust the scale of the X-axis on a chart? I can adjust the scale on the Y-axis fine, but the X-axis scale is darkened, and not selectable. Thanks.
Last edited by harrington77 on Sun Apr 27, 2008 5:54 pm, edited 1 time in total.
windows XP, OOo 2.4
Re: Adjusting X-axis scale
I've never seen that before, any chance you could upload a sample?I can adjust the scale on the Y-axis fine, but the X-axis scale is darkened, and not selectable.
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
Re: Adjusting X-axis scale
Change the chart type from "line diagram" to "x/y scatter".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 5
- Joined: Sun Apr 27, 2008 7:29 am
Re: Adjusting X-axis scale
Thanks Villeroy. Changing to and X-Y Scatter did the trick. After changing the chart type I was able to manipulate the scale on the X-axis. Initially, however, the data from the X-axis was blanked for some reason. Instead of having my dates (which were my X-axis data) along the X-axis, there merely were ascending number values (1-140 for each of my 140 data points). However, after going to Data Ranges, under the Format menu, and then selecting the Data Series tab, I was able to manually enter the data range for the Range for X-values, which solved the problem. Thanks for your help. I do wonder, though, why the scale on the X-axis is not manipulatable in a line-chart. Is this a flaw in the program? P.S., how did you know that switching to an X-Y Scatter would help? Thanks again.
windows XP, OOo 2.4
-
- Posts: 5
- Joined: Sun Apr 27, 2008 7:29 am
Re: [Solved] Adjusting X-axis scale
Cambirder, sorry, I have not found a way to capture an image of the pop-up screen that one gets when double-clicking on an axis. For whatever reason, whenever making line charts (but not X-Y Scatters) the scale of the X-axis is not manipulatable.
windows XP, OOo 2.4
Re: Adjusting X-axis scale
Line charts use discrete string values. Could be as well: John, Mary, Peter, ... whereas x/y-scatters assume 2 numeric scales. The x-axis is a continuous numeric sequence which can be scaled.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice