First time here? Check out the FAQ!
asked 2012-04-20 02:44:33 +0200jey2
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.
answered 2012-04-21 01:29:05 +0200mikebibo
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.
answered 2012-04-21 11:25:31 +0200Pedro
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-04-20 02:44:33 +0200
Seen: 3,038 times
Last updated: Apr 21 '12