Select a suitable trendline (with equation) and then click Close.
Note that the two series that have been defined/plotted are shown with different marker types.Ĭlick on one of the first 5 data points to select the data series and then click on the Layout tab under Chart Tools.Ĭlick Trendline and select More Trendline Options from the bottom of the dropdown menu that appears. Your graph should now look like the figure opposite. Leave the Series Name blank and click OK (twice). Select the remaining Series X values and Series Y values (in this case A7- A13 and B7- B13 respectively). In the Select Data Source window click Add. Leave the box next to Series Name blank and click OK. the first 5 data points):Ĭlick on the graph, then click the Design tab under Chart Tools.Ĭlick on the Select Data icon, then select Series 1 and then click Edit.Ĭlick the box under Series X Values and then highlight cells containing the first 5 x-values (in this case A2 to A6).Ĭlick the box under Series Y Values and then highlight cells containing the first 5 y-values (in this case B2 to B6). To only analyse and add a trendline to the initial rise in profit (i.e.
The following directions apply to Calc versions 2.0, 2.1, and 2.2.
Distribution of 3.0 and 3.1 on Windows continue to use a semi-colon.Įxcel 2007 uses different screens to obtain a linear regression.Ĭreating an xy scattergraph in Calc 2.0 3.0 and 3.1 on Ubuntu 9.04 and 9.10 respectively use a comma. Excel uses a comma by default, OpenOffice 2.0 a semi-colon. To obtain the slope and intercept in Excel for the above data, use the following functions: