Ask Your Question

Assigning X axis to a Spreadsheet column [closed]

asked 2012-04-20 02:44:33 +0200

jey2 gravatar image

I want the chart (XY line plot) to take X values from Column B. The values are irregularly incremented (for example, 2.3, 3.7, 6.1, 10.7, 13.9, etc.) But they are sorted. Y values are taken from Columns F and G. I can set the two Y series, but how do I set the series for the X axis.

Thanx for the help.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-14 01:06:41.611075

3 Answers

Sort by » oldest newest most voted

answered 2012-04-21 01:29:05 +0200

mikebibo gravatar image

On my system (LibreOffice 3.5.2, Linux), the first column was automatically assigned to the x-axis.

However, full manual control is available through the 'Data Series' step (step 3) of chart generation or via the 'Data Ranges' dialogue box of an existing chart: select the 'Data Series' tab. You can then manually select the range for 'X-Values' for each data series.

If the column you want to use for x-axis values is listed as a data series itself, you can simply remove it from the list of data series.

edit flag offensive delete link more


hey, it worked, at the same time Y-values can also be corrected if needed

salvador_sanchez gravatar imagesalvador_sanchez ( 2014-08-31 08:15:07 +0200 )edit

answered 2012-04-21 11:25:31 +0200

Pedro gravatar image

The fastest way to have this done automatically is to select data in column B then press and hold the Ctrl key while you select the data in columns F an G. When you press the Chart button (or menu Insert, Chart) just change the chart type to XY (Scatter) and you should see that the first series is the X-axis.

edit flag offensive delete link more

answered 2013-11-10 14:55:00 +0200

w34 gravatar image

I think the solutions that have been submitted so far are all fine and good if you're using a XY scatter plot, but with other chart types (such as column charts or bar charts), there often isn't a data range for 'X-values' under 'Data series'.

What helps in these cases is inserting the range you'd like to use as your 'X-values' in 'Categories' under 'Range of Y-Values'. Here's a screenshot of where you should insert the range you want to use:

edit flag offensive delete link more


The nomenclature in charts-wizard is quite confusing for me too. I have learnt to consider "categories" as "classes" in a bar chart of frequency distribution and then it makes sense to me that the X-axis values be called categories! The genesis might be different but it helps me. I still don't know what is "Name", "range of Name" and "First Row / First column as Label". I just click whatever brings my charts closer to my anticipation!! Hint: My charts are really simple and data quite intuitive.

vo81 gravatar imagevo81 ( 2014-01-17 15:44:12 +0200 )edit

Thank you, this fixed my problem. I would upvote, but I don't have enough karma.

mr_fnord gravatar imagemr_fnord ( 2015-02-25 15:51:18 +0200 )edit

Same for me here. After using a XY scatter plot, I had two entries in Data ranges ("X-Values", "Y-Values") for each Data series...

falstaff gravatar imagefalstaff ( 2016-01-22 01:43:06 +0200 )edit

Confession: I wasted quite a while trying to get X-values into a line graph, because I failed to understand its difference from a scatter plot. Changing the chart type to scatter fixed it.

ducked gravatar imageducked ( 2020-08-26 05:40:19 +0200 )edit

* best solution in this thread. it took me almost 2 hours of researching how i can solve this problem. god bless you all.

fishrot gravatar imagefishrot ( 2021-04-21 13:50:50 +0200 )edit

Question Tools

1 follower


Asked: 2012-04-20 02:44:33 +0200

Seen: 66,303 times

Last updated: Nov 10 '13