A trendline in Excel is a straight or curved line on an Excel chart that indicates the main pattern or direction of the data. It is an analytical tool. A trendline in Excel is typically used to illustrate data changes over time or the relationship between two variables. The main focus of this article is to explain how to add trendline in Excel online.
Download Practice Workbook
5 Steps to Add Trendline in Excel Online
To explain this article, I have taken a dataset that contains Months and Sales. I will use this dataset to make a chart and then add trendline in Excel online.
Let’s see the steps of adding trendline in Excel online.
Step-01: Inserting Chart
In this first step, I will insert a chart for the dataset I took.
- Firstly, select the dataset.
- Secondly, go to the Insert tab.
- Thirdly, select the Insert Chart option.
Now, you will see a drop-down menu that will open.
- Next, select the chart type you want for your dataset. Here, I selected Line with Marker.
Here, you will see a line chart has been inserted into your worksheet.
Now, you can format the chart as you want.
- Firstly, Right-click on the chart.
- Secondly, select Format.
Here, the Chart Format option will appear on the right side of the screen.
- Firstly, select Chart Title.
- Secondly, write the title you want for your chart.
- Thirdly, format the title as you want. Here, I made it bold.
- After that, select Series 1.
- Next, change the Series Name as you want.
- Then, select the Outline to change the color of the chart.
Here, you will see a list of colors that will appear on the screen.
- After that, select the color you want. Here, I selected the marked color in the following picture.
Now, you will see that you have got your desired chart in Excel online.
Read More: How to Calculate Trend Analysis in Excel (3 Easy Methods)
Step-02: Adding Trendline in Excel Online
In this step, I will explain how to add a trendline in Excel online on the chart I inserted.
- Firstly, Right-click on the line of the chart.
- Secondly, select Format.
Here, the Chart Format option will appear on the right side of the screen.
- Now, select Add Trendline 1.
Here, you will see the options for the Trendline.
- After that, select the Trend type. Here, I selected Linear.
Now, you will see that a linear trendline has been added to your line chart.
Read More: How to Extend Trendline in Excel (with Easy Steps)
Similar Readings
- Find Slope of Polynomial Trendline in Excel (with Detailed Steps)
- Make a Polynomial Trendline in Excel (2 Easy Ways)
- How to Extrapolate Trendline in Excel (4 Quick Methods)
Step-03: Formatting Trendline in Excel Online
In this step, I will show you how to format trendline in Excel online.
- Firstly, Right-click on the trendline.
- Secondly, select Format.
After that, the Chart Format option will appear on the right side of the screen.
- Thirdly, select Outline to change color.
Here, you will see a list of colors will appear.
- Now, select the color you want for your trendline. Here, I selected the marked color in the following Image.
Now, you can see that I have my desired trendline.
Step-04: Using Trendline in Excel Online to Forecast Future Data
In this step, I will explain how to use trendline to forecast future data.
- Firstly, Right-click on the trendline.
- Secondly, select Format.
Here, the Chart Format option will appear on the right side of the screen.
- After that, select the Forward period after which you want to see the Forecast.
Now, you can see that the trendline is showing the forecast of the future data for the next month.
Read More: How to Create Monthly Trend Chart in Excel (4 Easy Ways)
Step-05: Adding Multiple Trendlines in Excel Online
In this step, I will explain how to add multiple trendline in Excel online.
- Firstly, Right-click on the trendline.
- Secondly, select Format.
Here, the Chart Format option will appear on the right side of the screen.
- Now, select Add Trendline 2.
- After that, select Trend Type as you want. Here, I have selected Moving Average.
At this stage, you will be able to see that another trendline has been added to your line chart.
Finally, you can see that I have added trendline in Excel online in the following image.
Things to Remember
- One thing to keep in mind is that if you use more than 1 trendline, make sure you use different colors for each trendline for better visualization.
Practice Section
Here, I have provided a practice sheet for you to practice adding trendline in Excel online.
Conclusion
To conclude, I tried to explain detailed steps of how to add trendline in Excel online. These steps are effective and easy to follow. I hope this article was helpful for you. To get more articles like this visit ExcelDemy. If you have any questions feel free to let me know in the comment section below.