How to Add a Trendline in Excel

How to Add a Trendline in Excel

In this tutorial, we’re going to cover how to add a trendline in Excel. This element is invaluable when you need to make a clear and neat visual representation of the data trend.

Let’s start!

See the video tutorial and transcription below:

See this video on YouTube:

To use the trendline function in Excel, you’ll need to organize data into a chart first. For more information on how to make a bar chart or for some useful advice on making graphs, watch more video tutorials by our team. You can find the links in the description below.

Now, we’re gonna go through how you can add a trend line into a chart. This tutorial also shows how you can format the trend line or how to remove it from the chart completely in case you don’t need it anymore.

We’ll go through each step now, starting with the first one.

To add a trend line to this bar chart, click on the graph. Then click on this green plus sign icon located on the right-hand side, which opens a list of options. Here you can select or deselect various chart elements.

How to Add a Trendline in Excel - adding trendline in Excel

We want to display a trend line, so hover over ‘Trendline’ and click on the arrow that appears next to the text.

How to Add a Trendline in Excel - how to create trendline in Excel

Choose the trend line type you need, for example, linear, exponential, or any other type. In this case, we’ll go for the first one, so click on ‘Linear’.

How to Add a Trendline in Excel - create trendline in Excel chart

Once it’s been selected, we can have a look at how we could format the trend line and change it depending on what we need.

How to Edit (Format) a Trendline in Excel

If you want to format the trend line, click on the line with the right mouse button.

How to Add a Trendline in Excel - how to format trendline in Excel

Select ‘Format Trendline’.

How to Add a Trendline in Excel - format trendline in Excel

On the right-hand side, you’ll see a task pane with more options. Here we can take a moment to go through the basic ones.

In the section ‘Trendline Options’, you can change the type of the trend line.

How to Add a Trendline in Excel - what are trendline options in Excel

If you need to change the colour of the line, you can go to the section ‘Fill & Line’.

How to Add a Trendline in Excel - how to fill and line trendline in Excel

Here you can set the desired colour,

How to Add a Trendline in Excel - How to set colour of trendline in Excel

along with ‘Transparency’, the width or other parameters.

How to Add a Trendline in Excel - setting of trendline in Excel

How to Remove a Trendline in Excel

Let’s close the task pane now and let’s have a look at the last point of the tutorial – how to remove the trend line from the chart completely.

Simply, click on the chart, then the green plus sign icon, and the options which you’re already familiar with appear. Simply unselect ‘Trendline’.

How to Add a Trendline in Excel - removing trendline in Excel

And that’s it! The trend line has been removed from the chart.

If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! You may also find Excel Analyst Jobs with Jooble.

Thanks for watching and I’ll see you in the next tutorial!


Add comment

Your email address will not be published. Required fields are marked *

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.