Showing a trend as a percentage?

[Ariakan]

Hi All

I have the following data from a worksheet detailing an individuals performance over time.

23MAY 30MAY 6JUN 13JUN 20JUN 27JUN 4JUL 11JUL 18JUL 25JUL 01AUG
86.25 67.05 85.53 57.87 83.67 64.94 92.84 117.71 - 70.25 90.31

08AUG 15AUG
84.84 88.05

I know how to use a chart with trendline to show that performace is increasing over this period. The sheet in question tells me that this individual is on a 13.95% upward trend - how is this worked out? The sheet has no reference to any other cells/formulas - I suspect the value was pasted in - the creator is on holiday for 2 weeks.

Any help will be greatly appreciated,

Thanks.

 

[Steve=True]

Depends on which trendline you are picking.

However, here is a great article from MrExcel, Bill on using linest to calculate a trendline

http://officeimg.vo.msecnd.net/en-us/files/752/501/AF010285755.mht


Steve=True
http://www.exceldashboardtemplates.com/?p=604