Frequently asked questions - Calc
From The Document Foundation Wiki
- 1 How to place the axes where you want them in a chart of type X-Y
How to place the axes where you want them in a chart of type X-Y
Several cases can be envisaged.
A series of negative data with the 'X' axis at trhe top of the screen
- Select the data series: in the first column of the sheet, the X-axis data; in the second column, the negative Y-axis data.
- Go to ▸ and choose chart type XY
- LibreOffice will automatically put the origin of the axes at the top of the chart.
A series of positive and negative data
By default the X-axis is placed at zero on the Y-axis. You can however position it relative to the Y-axis at any value you want.
- Double-click the chart to select it. A gray line should appear around it.
- Right-click on the Y-Axis to open its contextual menu.
- Choose Format axis
- In the new window, select the Position tab
- In the Cross other axis at Value box, enter the value you want.
Two series, one with only negative values, the other with only positive values
In fact we need to create a 'pyramid of ages'.
- Create a chart of type Bars, Stacked, no grid.
- You can put the vertical axis where you like (in this case it will be the X-axis).
- Create a chart of type Columns, Stacked, no grid.
- You can put the horizontal X-axis where you like in the same way as before.