EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Statistical Functions in Excel Excel Trendline
 

Excel Trendline

Madhuri Thakur
Article byMadhuri Thakur

Updated June 8, 2023

Trendline in Excel

 

 

Trendline in Excel

The trendline in Excel is part of all the Charts available in the Charts section under the Insert menu tab, which is used to see the trend in the plotted data over any chart. This helps us to see whether there is an increase or decrease in data values. This is also helpful in seeing at which point the data goes up or down. It can be used in any chart type (Except Pie, Donuts). To apply trendline, create a chart using the option available in the Charts section, then click right on any data on the chart and select Add Trendline. We can also insert Trendlines using the Chart Elements list, accessed from the plus sign at the top right corner or any chart.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Types of Trendlines in Excel

There is various type of trendlines in excel:

  1. Exponential trendline
  2. Linear trendline
  3. Logarithmic trendline
  4. Polynomial trendline
  5. Power trendline
  6. Moving Average trendline

Now we will explain one by one the types of Trendline in Excel.

Exponential:

This trendline is mostly used where the data rise or falls constantly. Avoid this trendline if the data contains zero or negative values.

Linear:

This trendline is useful for creating a straight line to show the increasing or decreasing of data values at a straight line.

Logarithmic:

This trendline is useful where the data suddenly increases or decreases and then becomes stable at some point. In this trendline, you can include the negative values in the dataset.

Polynomial:

This trendline is useful where you see gain or loss in the business. The degree of this trendline shows the number of fluctuations in the data.

Power:

This trendline is useful where the dataset compares results that increase at a fixed rate. Avoid this trendline if your dataset contains Zero or negative values.

Moving Average:

This trendline shows the pattern clearly in the dataset, which smoothes the line. This trend is mostly used in Forex Market.

How to Create a Trendline in Excel?

Creating a Trendline in Excel is very simple and easy. Let’s understand the creation of Trendline in Excel with some examples.

You can download this Trendline Excel Template here – Trendline Excel Template

Example #1

Suppose we have given the fruit’s name & their production number month wise.

Trendline (production number )

To create a trendline in Excel, follow the below steps:

  • Select the whole data, including the headings.
  • Go to the INSERT tab.
  • Click on Column Charts under the Charts section and then select 2-D Column Chart, as shown in the below screenshot.

Insert Colums

  • It will create a Column chart on the given data, as shown below.

Trendline (create a Column chart)

  • After formatting Legend and adding the chart title, the chart will look as below:

Trendline (formatting Legend)

  • Click on Chart Area and do right-click. It will open a drop-down list of some options, as shown in the below screenshot.

drop-down list

  • Click on Add Trendline option from the drop-down list.

Add Trendline

  • It will open a Format Trendline box, as shown in the below screenshot.

Format Trendline

  • Make sure that the Linear option is selected. Refer to the below screenshot.

Trendline (Linear)

  • You can format the trend line using the Fill & Line option.
  • It will create the linear trendline in your chart, as shown below.

Trendline (Chart title)

  • Through this trendline, we can predict the growth of the business.

growth of the business

Example #2

We have given the sales amount period-wise.

sales amount period

To create a trendline in Excel, follow the below steps:

  • Select the whole data, including Column headings.
  • Go to the Insert tab, choose the Line chart, and click OK. Refer to the below screenshot.

Insert and click ok

  • The chart is shown below:

Trendline salesamount

  • Now do, right-click on the line of a line chart and choose the option Add Trendline. Refer to the below screenshot.

 option Add Trendline

  • It will open the Format Trendline window.
  • Make sure that the Linear option is selected.

Format Trendline window

  • Now close the window, and it will insert the trendline in your chart. Refer to the below screenshot.

in your chat

Now from the trendline, you can predict the flow of business growth.

Things to Remember

  • Check for the R-squared value to know the most suitable trendline for your dataset.
  • When R-value is at or near 1, it’s most reliable.
  • When you create a trendline for your chart, it automatically calculates R squared value.

Recommended Articles

This has been a guide to Trendline in Excel. Here we discuss its types and how to create a trendline in Excel, along with Excel examples and a downloadable Excel template. You may also look at these useful charts in Excel –

  1. Excel Column Chart
  2. Excel Clustered Column Chart
  3. Excel Stacked Column Chart
  4. Excel Scatter Chart

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Trendline Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Trendline Excel Template

EDUCBA

डाउनलोड Trendline Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW