Skip to content Skip to navigation

Connexions

You are here: Home » Content » Steps to Create a Linear Trendline in Microsoft Excel

Navigation

Content Actions
  • Download module PDF
  • Add to ...
    Add the module to:
    • My Favorites
    • A lens
    • An external social bookmarking service
    • My Favorites (What is 'My Favorites'?)
      'My Favorites' is a special kind of lens which you can use to bookmark modules and collections directly in Connexions. 'My Favorites' can only be seen by you, and collections saved in 'My Favorites' can remember the last module you were on. You need a Connexions account to use 'My Favorites'.
    • A lens (What is a lens?)

      Definition of a lens

      Lenses

      A lens is a custom view of Connexions content. You can think of it as a fancy kind of list that will let you see Connexions through the eyes of organizations and people you trust.

      What is in a lens?

      Lens makers point to Connexions materials (modules and collections), creating a guide that includes their own comments and descriptive tags about the content.

      Who can create a lens?

      Any individual Connexions member, a community, or a respected organization.

    • External bookmarks
  • E-mail the author

Recently Viewed

This feature requires Javascript to be enabled.

Steps to Create a Linear Trendline in Microsoft Excel

Module by: Jerry Visser

Summary: After creating a chart in MS Excel, insert a trendline for the data series.

Trendline

Overview

Microsoft Excel is commonly used for business analysis of data sets. For this example, MS Excel 2007 will be used.

Start Point

The starting point for this example will be a pre-existing chart.

Steps

Right mouse click on the data series.

Select Add Trendline. (Figure 1)

Figure 1
Figure 1 (graphics1.jpg)

Choose Linear.

Optionally select “Display Equation on chart”

Forecast forward 1 to 2 periods for effect

Comments, questions, feedback, criticisms?

Send feedback