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.
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.
hey, it worked, at the same time Y-values can also be corrected if needed
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.
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
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.
Thank you, this fixed my problem. I would upvote, but I donât have enough karma.
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âŚ
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.
***** best solution in this thread. it took me almost 2 hours of researching how i can solve this problem. god bless you all.
