How to Add Multiple Trendlines in Excel (With Quick Steps)

The trendline is a very common and important feature in the field of data analysis, business forecasting, decision making for stakeholders and many more. Therefore we need to know how to add a trendline in excel. In this article, we will get to know the trendline a little more and afterward we will learn how to add multiple trendlines in excel with quick steps.

Download Workbook

Get the sample file here and download it by yourself.

What Is Trendline?

In easy language, a trendline is basically a straight or curved line that illustrates the pattern or direction of a dataset. It generally gives information on data differences or data movements over a period of time. It also shows the interrelation between variables. The trendline can be expressed through column chart, line chart, scattered chart etc. The number of trendlines depends on the number of data types selected in excel.

Step by Step Procedures to Add Multiple Trendlines in Excel

Now, we will go through the step-by-step procedures to add multiple trendlines in excel. Simply follow the steps below:

Step 1: Prepare Dataset in Excel

To get the best output, we need a proper dataset. Here we will prepare a dataset on project numbers of 4 employees in a company for the first half months of a year.

• First, insert months in range B4:B10.
• After that, put the numbers of projects in each employee’s section (range C4:F10)

• That’s it. We have our required dataset to work on.

Read More: How to Calculate Trend Analysis in Excel (3 Easy Methods)

Step 2: Create Column Chart with Dataset

The trendline can be placed on different types of charts. Here we will create a column chart. To perform this, follow the steps below:

• First, select the Dataset you want to create a column chart with.

• Secondly, go to the Insert tab and select Recommended Charts.

• After that, a new window named Insert Chart will appear.
• In this window, select the Clustered Column among the Column option in the All Charts section.

• Finally, we have our column chart.

Read More: How to Select Data for a Chart in Excel (2 Ways)

Step 3: Add Single Trendline from Dataset

As we have our chart now, we will add our first trendline. Let’s look at the steps below:

• First, select the Column Chart and click on the Plus (+) icon beside this.
• Then, from the drop-down section, click on Trendline.

• It will then open a new window Add Trendline asking which data series you want to include. For example, we have chosen Martin here.
• After that, press OK.

• Finally, you can see our first trendline in the column chart.

Read More: How to Add a Trendline to a Stacked Bar Chart in Excel (2 Ways)

Similar Readings

• How to Create Excel Chart Using Data Range Based on Cell Value
• Make a Polynomial Trendline in Excel (2 Easy Ways)
• How to Find the Equation of a Trendline in Excel (3 Suitable Ways)
• Selecting Data in Different Columns for an Excel Chart
• How to Change Chart Data Range in Excel (5 Quick Methods)

Step 4: Add Multiple Trendlines

Our main target is to add multiple trendlines to this column chart. Now we will do that with the steps below:

• Follow the similar procedure that we used to add a single trendline.
• In this case, you have to select the Name of the Data Series each time you need to insert a trendline for that.
• Following that, we have successfully added multiple trendlines in excel.

Read More: How to Create Monthly Trend Chart in Excel (4 Easy Ways)

Step 5: Format the Trendlines

At this stage, we will edit and customize the trendlines that we added to the column chart because by default their appearance is not clean and easy to understand.

• Firstly, select any one trendline from the chart.
• Secondly, right-click and select Format Trendline from its Context Menu.

• After that, change the Line to Solid Line.
• Along with it, change the Color and Dash type as well.

• Finally, we have a clear trendline on the first selected data series.

• Following the similar procedure, we can format other trendlines as well.
• Afterward, we also changed the Chart Style from the Styles section.

• Finally, we have successfully added multiple trendlines in excel with the necessary customization.

• You can also edit and customize the trendlines along with the chart from the Chart Design tab.

• Explore more options to customize trendline from the Format Trendline panel and Chart Design tab.

Read More: How to Extend Trendline in Excel (with Easy Steps)

How to Remove Trendline in Excel

The process to remove single or multiple trendlines in excel is very simple and easy. Let’s see how to do that.

• In the beginning, select the chart and click on the Plus (+) sign.
• Then, remove the Tick Mark from the Trendline in the Chart Elements section.

• In the end, you see that the trendlines are not visible in the chart anymore.

Conclusion

In concluding the article, hope that it was a useful one on how to add multiple trendlines in excel with some quick steps. Let us know your feedback on this article in the comments section.

Related Articles

• How to Import and Use Data into Power Pivot in Excel
• Find Slope of Trendline in Excel (2 Easy Methods)
• Calculate Trend Percentage in Excel (With Easy Steps)
• How to Add Trendline Equation in Excel (With Easy Steps)
• Find Slope of Polynomial Trendline in Excel (with Detailed Steps)
• How to Create a Scatter Chart in Excel (with Easy Steps)