Page 1 of 1
change x axis
Posted: Mon Aug 25, 2008 9:25 pm
by crossd
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
Re: change x axis
Posted: Mon Aug 25, 2008 9:37 pm
by Cambirder
In edit mode go to data range and tick "First column as label"
Re: change x axis
Posted: Mon Aug 25, 2008 11:23 pm
by crossd
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
Re: change x axis
Posted: Tue Aug 26, 2008 3:12 am
by Cambirder
Any chance you can upload the file here?
Re: change x axis
Posted: Tue Aug 26, 2008 3:26 am
by acknak
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.
Re: change x axis
Posted: Tue Aug 26, 2008 3:34 pm
by jrkrideau
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