Buy Now

How to Add a Trend-line in Excel Online

Jan 05, 2023
how-to-add-a-trend-line-in-excel-online

Here's a quick step-by-step guide for how to add a trendline in Excel Online via a Line Chart.

  1. Highlight the data table, head to the insert tab, and then Recommended Charts.

  2. Choose All Charts, Line, then hit OK.

  3. Right-click on the line within your line chart and choose to Add Trendline.

  4. Choose Linear, then close the Format Trendline Pane.

You can follow the same process for adding a trendline into a bar chart.

Suggested read: What is Macro Button in Excel, and How to Create One?

Different types of Trendlines

There is more than one type of Trendline in Excel Online for you to take advantage of.

  • Logarithmic Trendline: Perfect for highlighting data that rises or falls quickly before leveling out.

  • Exponential Trendline: This Trendline highlights the increase or decrease in a data value, often through a curved trend line.

  • Linear Trendline: This straight-line Trendline highlights the increase or decrease in data value.

  • Moving Average Trendline: This Trendline is used to smoothen extreme fluctuations in data, to help establish a more transparent data trend.

  • Polynomial Trendline: Perfect for highlighting fluctuating data that doesn't follow a simple rise and fall.

Suggested read: Pivot Table Training for Excel

Format the Trendline

Once you are comfortable adding trendlines in Excel Online, we can focus on formatting your trendlines. Formatting includes changing your trend line's width, color, transparency, and other aspects.

To format your trend line:

  1. Right-click Trendline.

  2. Choose the Format Trendline option, and the Format Trendline window will open.

  3. From that window, select fill & line.

  4. Choose your color, amend the width, and alter the transparency.

Use Trendlines to Forecast Future Data

One of the best benefits of using a trendline in Excel Online is that you can project data trends into the future.

  1. Double-click on your trend line and open the Format trendline pane.

  2. Choose the Trendline Options tab.

  3. Select how many periods you want to create from the forecast and type that number in the forward box.

Add multiple trendlines to the same chart.

We have only focused on adding one Trendline in Excel Online. Now, let's focus on adding multiple trend lines.

For this example, let's say you want to add a moving average and a linear trendline to your spreadsheet. Add your moving average Trendline using the steps outlined above, and then follow these steps to add your linear Trendline.

  1. Select the Char Elements option from the right-hand corner of your chart

  2. Select the arrow that sits next to Trendline.

  3. Choose Linear Trendline from the list.

  4. Select where you want to see your linear Trendline.

You should see more than one Trendline in Excel Online if done correctly.

How to remove Trendline in Excel

If you have a trendline in Excel Online that you would like to remove, perhaps because it is not highlighting a data point as you had hoped, it is quick and easy.

  1. Select Excel Chart.

  2. Select the Chart Elements option from the right-hand corner of your chart.

  3. Uncheck the trend line box. If you do this correctly, you will see the straight or curved line disappear.

Want to Make Excel Work for You? Try out 5 Amazing Excel Templates & 5 Unique Lessons

We hate SPAM. We will never sell your information, for any reason.