change x axis

Discuss the spreadsheet application

change x axis

Postby crossd » Mon Aug 25, 2008 9:25 pm

how do i change the x axis on a chart created out of a spreadsheet from a row number to a column of data in the spreadsheet?
can't find it in spreadsheet help.

dc
OOo 2.3.X on Ms Windows XP + ms vista
crossd
 
Posts: 2
Joined: Mon Aug 25, 2008 9:20 pm

Re: change x axis

Postby Cambirder » Mon Aug 25, 2008 9:37 pm

In edit mode go to data range and tick "First column as label"
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: change x axis

Postby crossd » Mon Aug 25, 2008 11:23 pm

thanks cambirder i can't seem to make it work.
i've got 4 columns..a,b,c,d..i am plotting column d and have that range on the y axis..
when i do what you say.. putting 'First column as label' which is what i want as that is a date column..the chart insists on changing the scale of the y axis to that of column B!!..what gives?

donc
OOo 2.3.X on Ms Windows XP + ms vista
crossd
 
Posts: 2
Joined: Mon Aug 25, 2008 9:20 pm

Re: change x axis

Postby Cambirder » Tue Aug 26, 2008 3:12 am

Any chance you can upload the file here?
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: change x axis

Postby acknak » Tue Aug 26, 2008 3:26 am

how do i change the x axis ... from a row number to a column of data...?

If both the x- and the y-values come from data in the spreadsheet, you have to use an X-Y chart.

First you have to do Format > Chart Type, and set the type to "XY".

Then Format > Data Ranges > Data Series and set a range for the x-values.
AOO 4 • Linux • Fedora 17
User avatar
acknak
Moderator
 
Posts: 17399
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: change x axis

Postby jrkrideau » Tue Aug 26, 2008 3:34 pm

crossd wrote:thanks cambirder i can't seem to make it work.
i've got 4 columns..a,b,c,d..i am plotting column d and have that range on the y axis..
when i do what you say.. putting 'First column as label' which is what i want as that is a date column..the chart insists on changing the scale of the y axis to that of column B!!..what gives?

donc


It sounds like you are trying to graph an xy chart using something like a line chart.
Try it with an xy-chart and see what happens
AOO 4.0.1, Ubuntu 13.04
jrkrideau
 
Posts: 1910
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada


Return to Calc

Who is online

Users browsing this forum: jakemun and 14 guests