How to add a trendline in excel chart (Easy Steps)

July 22, 2022
1.1K Views
0

A free Office suite fully compatible with Microsoft Office

You may have set yourself the goal of knowing how to add a trendline in Excel, but it has been challenging to meet the objective due to a lack of information. It is time to learn how to add a trendline in Excel Mac or Windows through a straightforward method. Likewise, you will know how to display the equation on the trend line and even how to format this tool.

It is good that you are serious about learning how to add a trendline in excel Online to get the most out of the method. On the other hand, you should take this method of how to add a trendline in excel as an initiation to understand the tool available in the official program.

How to add a trend line in Excel to a chart?

If you want to know how to add a trendline in excel without problems, it is good that you apply a simple method like the following:

1. Open the Excel document where you want to place the trend line for a company chart.

2. If you don't have the chart, you will only have to create it by going to the insert tab and then clicking on charts. Eventually, you will have to select the graphic most appealing to you.

3. With the graph available in the Excel document, you will have to select it at any end and click on the more option with its corresponding icon.

4. Now, the graph options will appear where you must mark the trend line located at the end of the list.

5. If you need to adjust the trend line, you will only have to click on the key at one end.

How to display the equation on a trend line in Excel?

Now that you understand how to add a trendline in excel 2019, you can customize the tool to your liking. In this case, you will learn how to display the equation in a trend line after following these steps:

1. Open the Excel document where you already have the graph and the trend line already created.

2. You will have to double-click on the trend line to access its control panel.

3. Within the panel, you must go to the trend line options tab. Eventually, check the boxes show equation on the graph and show R-squared value on the graph. Click OK and save the changes.

How can a trend line be formatted in Excel?

One last thing you should consider when knowing how to add a trendline in excel 2016 is to format that tool. If you intend to format your trendline, you will need to:

1. You must select the graph with the previously created trend line and click on more.

2. You will have to put the mouse cursor on the arrow with a direction to the right located on the trend line. Then click on more options.

3. Within the trend line format panel, you will see several options to change the style of the trend line. In the second option, you will find the effects of the trend line, and in the third option, you will find the element's shape.

You already have the necessary information to know how to add a trendline in Excel and even modify it to your liking. If all the information has been helpful to you and you want to know more about Excel, you should go to WPS Academy. On the website, you will learn how to use Excel, PowerPoint, and Word, and you will be allowed to download WPS Office for free.