Click Trendline and select More Trendline Options from the bottom of the dropdown menu that appears.
Click on one of the first 5 data points to select the data series and then click on the Layout tab under Chart Tools. Note that the two series that have been defined/plotted are shown with different marker types. 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. Click the box under Series Y Values and then highlight cells containing the first 5 y-values (in this case B2 to B6). Click the box under Series X Values and then highlight cells containing the first 5 x-values (in this case A2 to A6). Click on the Select Data icon, then select Series 1 and then click Edit. Click on the graph, then click the Design tab under Chart Tools. To only analyse and add a trendline to the initial rise in profit (i.e. PChem Teaching Lab| Excel 10 Using Excel 2010 - Add a Trendline to part of a Graph Add Multiple Trendlines to a Graph ADD A TRENDLINE TO PART OF A GRAPH Enter the data opposite onto Sheet4 and generate a graph so that your worksheet looks like the one displayed. Excel draws the two ends of the trend line. Microsoft Excel 2010 lets you add a trend line to a chart in a spreadsheet to represent your data's current and future trends. Share Share on Facebook Data forecasting with a trend line is a practical method for determining future data values.