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.
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
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
