HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: How To Add a Trendline to a Chart

Excel 2007: How To Add a Trendline to a Chart

Trendlines are useful for revealing patterns or trends in your data. They are mostly used in XY scatter charts but are also useful in line, area, and bar charts. To add a trendline to your chart, follow these instructions…


1. Select the chart.

2. Select the series you wish to use to create the trendline.

3. Go to Chart Tools, select the Layout tab and click Trendlines.

4. Select the type of relationship you are expecting the data to reveal, your choices are Linear, Exponential, Linear Forecast, or Two Period Moving Average. You can also select More Trendline Options to reveal even more types.

5. Right-click the newly created trendline and select Format Trendline. Use the Line Color, Line Style and Shadow sections to modify the look of the trendline.

6. Click Close.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

19 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android