Ask Your Question
0

Assigning X axis to a Spreadsheet column [closed]

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

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

Comments

Just wanted to mention that I spent a lot of time, trying to fix that for NOT XY Scatter chart. If you want to set the values for the X axis on different chart, simply go to: Data Ranges >> Data Series, and type in the "Category" field the appropriate column in the sheet you want to use ($'DataRange'.$I$18:$I$47)

pastet89 gravatar imagepastet89 ( 2015-12-16 22:02:40 +0100 )edit

3 Answers

Sort by » oldest newest most voted
1

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

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

Comments

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 +0100 )edit
1

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

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
0

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

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: http://i.imgur.com/85lF0Y9.png

edit flag offensive delete link more

Comments

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 +0100 )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 +0100 )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 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 58,202 times

Last updated: Nov 10 '13