[Solved] Adjusting X-axis scale

Discuss the spreadsheet application

[Solved] Adjusting X-axis scale

Postby harrington77 » Sun Apr 27, 2008 7:40 am

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
harrington77
 
Posts: 5
Joined: Sun Apr 27, 2008 7:29 am

Re: Adjusting X-axis scale

Postby Cambirder » Sun Apr 27, 2008 1:07 pm

I can adjust the scale on the Y-axis fine, but the X-axis scale is darkened, and not selectable.


I've never seen that before, any chance you could upload a sample?
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: Adjusting X-axis scale

Postby Villeroy » Sun Apr 27, 2008 1:26 pm

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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17295
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Adjusting X-axis scale

Postby harrington77 » Sun Apr 27, 2008 5:50 pm

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
harrington77
 
Posts: 5
Joined: Sun Apr 27, 2008 7:29 am

Re: [Solved] Adjusting X-axis scale

Postby harrington77 » Sun Apr 27, 2008 6:18 pm

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
harrington77
 
Posts: 5
Joined: Sun Apr 27, 2008 7:29 am

Re: Adjusting X-axis scale

Postby Villeroy » Sun Apr 27, 2008 6:27 pm

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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17295
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: Google [Bot], Villeroy and 22 guests