Select the ‘data series’ tab Any spreadsheet expects the first column to be x and the second y In chart edit mode, the chart is surrounded by a gray border
Picture of Mamrie Hart
Move the cursor over the x axis until a popup x axis appears
Then select the x axis with a single left click
Lo calc will display the chart object that's currently selected by showing little green squares After selecting the x axis, this should look similar to this: A series of negative data with the 'x' axis at trhe top of the screen select the data series Go to insert chart and choose chart type xy libreoffice will automatically put the origin of the axes at the top of the chart.
Editing chart axes to edit the axes of a chart that you have inserted A gray border appears around the chart and the menu bar now contains commands for editing the objects in the chart Select from the available sections and make the required changes (for example. Most calc charts require both value and category data, with values plotted along the y axis and categories plotted along the x axis
The exceptions are xy (scatter) charts and bubble charts, which use value data along both axes.
Use this area to assign a second axis to your chart If a data series is already assigned to this axis, libreoffice automatically displays the axis and the label. Almost because the chart object are moved to much to the left and i want them centered Try to scale the x axis manually (of the second sample graph) with an appropriate maximum value, what come the “centered” view
Or you can use a tricky third graph line as a “virtual x axis” with the showed x values as labels. Chart data values (for charts with own data) Chart type, axes, titles, walls, grid, and more