How to add trendline in excel online. Click on the arrow next to trendline. This will open up the format trend line window to the right end of the worksheet. In the add trendline dialog box select any data series options you want and click ok.
Select a data series excel displays the chart tools adding the design and format tabs. Under chart tools on the design tab in the chart layouts group click the add chart element icon and choose trendline list. The format trendline pane appears.
Lets add a trendline to a line graph. Select the to the top right of the chart. After clicking the plus icon found on the upper right side of the chart click the right arrow beside trendline and choose more options from the dropdown list.
Right click the data series select add trendline in the context menu and then choose a different trend line type on the pane. Choose a trendregression type. To apply the moving average trend line right click on column bars and choose add trend line.
Click the button on the right side of the chart click the arrow next to trendline and then click more options. Click on the chart elements icon on the top right corner of the chart. This adds the default linear trendline to the chart.
There are different trendlines available so its a good idea to choose the one that works best with the pattern of your data. Select the chart click the chart elements button and then click the trendline checkbox. To add a trendline select the data series and do one of the following.
Select two period moving average from the list. Select the series sales. Click the chart elements button click the arrow next to trendline and choose the type you want to add.