Formula to create a trend based on series of data

[khan_riyadh]

Dear Sir,

I would like to create a trend chart in percentage based on series of data below, as there is a 7% decrease between June 2015 and Oct 2014
Appreciate your help to have a formula in each cell to show a change and plot a chart

-7%
01/06/2015 250
17/05/2015 225
02/05/2015 213
17/04/2015 245
02/04/2015 232
18/03/2015 255
03/03/2015 262
16/02/2015 230
01/02/2015 225
17/01/2015 245
02/01/2015 250
18/12/2014 255
03/12/2014 260
18/11/2014 265
03/11/2014 270
19/10/2014 265
04/10/2014 270

[Kaper]

To see long time trens - use a trendline for all your data.
It is of course decreasing.
But local changes can be opposite - like in last period from May 2nd to June 1st there was 17% increase!

[JeteMc]

I hope that I understand what you want. I have included a couple of charts and hopefully one of them is the one you are looking for. I also assume that the dates shown in the original post work on your system. There are two formulas, the first is the % of original:

Please Login or Register  to view this content.

The second is % of change:

Please Login or Register  to view this content.

Here is the file with the formulas applied and charts included:

Trends.xlsx

Let me know if you have any questions.

[khan_riyadh]

Thank you for your file.
Appreciate if you could let me know as how you got the Y= -0.1609 x +7013.7 ?

Regards

[Kaper]

in formatting the trendline check "display trend equation on the plot"