One way to assess this fluctuating data is to add a linear trend line to the Excel 2013 graph. This visual element considers all the data and displays the overall direction the values are taking.

Add a linear regression line to the scatter chart by clicking the "Layout" tab, selecting the "Trendline" drop-down box and clicking "Trendline Options." Select the "Linear" option and click the ...

To add a regression line, choose "Add Chart Element" from the "Chart Design" menu. In the dialog box, select "Trendline" and then "Linear Trendline." To add the R 2 value, select "More Trendline ...

Step 3: Input Duration Data. The next step is to add another series to your Excel chart to reflect each task’s duration. To do this: Right-click on the chart and select “Select data” from ...

To add a regression line, choose "Add Chart Element" from the "Chart Design" menu. In the dialog box, select "Trendline" and then "Linear Trendline." To add the R 2 value, select "More Trendline ...