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.

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 a trendline in Excel online.

5 Steps to Add Trendline in Excel Online

Let’s see the steps of adding a trendline in Excel online.


Step-01: Inserting Chart in Excel

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.


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 Add Trendline Equation in Excel


Step-03: Formatting Trendline

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


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.


Download Practice Workbook


Conclusion

To conclude, I tried to explain in detailed steps how to add trendline in Excel online. These steps are effective and easy to follow. I hope this article was helpful for you. If you have any questions feel free to let me know in the comment section below.


Related Articles


<< Go Back To Add a Trendline in Excel | Trendline in Excel | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mashhura Jahan
Mashhura Jahan

Mashhura Jahan, BSc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology, invested 1.5 years at ExcelDemy. In roles like Excel & VBA Content Developer, Excel Charts, and Dashboard course trainer, she wrote 90+ articles. She was previously part of the forum support team and a junior software analyst on the Excel Add-in project. With interests spanning Excel, VBA, Power Query, Python, Data Science, and Software Development, Mashhura brings a diverse skill set to her... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo