To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose Insert Trend Line Equation. When the chart is in edit mode, LibreOffice gives you the equation of the trend line and the coefficient of determination R 2, even if they are not shown: click on the trend line to see the information in the status bar. Trend Line Equation and Coefficient of Determination To change the line properties, select the trend line and choose Format - Format Selection - Line. The trend line has the same color as the corresponding data series. Its name can be defined in options of the trend line.
A trend line is shown in the legend automatically. To rearrange a series, select it, and then click Move Up Move Up button or Move Down Move Down button.
In the Legend Entries (Series) box, click the series you want to change.Ĭlick Edit, make your changes, and click OK.Ĭhanges you make may break links to the source data on the worksheet. Right-click your chart, and then choose Select Data. Use chart filters to show or hide data in your chart. Use the Select Data Source dialog box to edit the data in your series or rearrange them on your chart.