How to Add Trendline in Excel Online (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.

5 Steps to 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.

Inserting Chart

  • 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.

Inserting Chart

Here, you will see a line chart has been inserted into your worksheet.

Inserting Chart

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.

Inserting Chart

  • 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.

Inserting Chart

  • 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.

Inserting Chart

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.

Adding Trendline in Excel Online

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.

Adding Trendline in Excel Online

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


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.

Formatting Trendline in Excel Online

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.

Formatting Trendline in Excel Online


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.

Using Trendline in Excel Online to Forecast Future Data

Now, you can see that the trendline is showing the forecast of the future data for the next month.

Using Trendline in Excel Online to Forecast Future Data

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.

Adding Multiple Trendlines in Excel Online

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.

Adding Multiple Trendlines in Excel Online

Finally, you can see that I have added trendline in Excel online in the following image.

Adding Multiple Trendlines in Excel Online


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.


Related Articles

Mashhura Jahan

Mashhura Jahan

Hey! Welcome to my profile. Currently, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo