Skip to content Skip to navigation

Connexions

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

Navigation

Recently Viewed

This feature requires Javascript to be enabled.

Steps to Create a Linear Trendline in Microsoft Excel

Module by: Jerry Visser. E-mail the author

User rating (How does the rating system work?)
Ratings

Ratings allow you to judge the quality of modules. If other users have ranked the module then its average rating is displayed below. Ratings are calculated on a scale from one star (Poor) to five stars (Excellent).

How to rate a module

Hover over the star that corresponds to the rating you wish to assign. Click on the star to add your rating. Your rating should be based on the quality of the content. You must have an account and be logged in to rate content.

:
(0 ratings)

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

Content actions

Give Feedback:

E-mail the module author | Rate module ( How does the rating system work?)

Rating system

Ratings

Ratings allow you to judge the quality of modules. If other users have ranked the module then its average rating is displayed below. Ratings are calculated on a scale from one star (Poor) to five stars (Excellent).

How to rate a module

Hover over the star that corresponds to the rating you wish to assign. Click on the star to add your rating. Your rating should be based on the quality of the content. You must have an account and be logged in to rate content.

(0 ratings)

Download:

Module PDF

Add module to:

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 (?)

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.

What are tags? tag icon

Tags are descriptors added by lens makers to help label content, attaching a vocabulary that is meaningful in the context of the lens.

| External bookmarks