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
change x axis
change x axis
OOo 2.3.X on Ms Windows XP + ms vista
Re: change x axis
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
Re: change x axis
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
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
Re: change x axis
If both the x- and the y-values come from data in the spreadsheet, you have to use an X-Y chart.how do i change the x axis ... from a row number to a column of data...?
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.
AOO4/LO5 • Linux • Fedora 23
Re: change x axis
It sounds like you are trying to graph an xy chart using something like a line chart.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
Try it with an xy-chart and see what happens
LibreOffice 7.3.7. 2; Ubuntu 22.04