Trend Arrows

[Jackgeorge]

Hi All
I'm creating a dashboard for reporting the sites performance and I would like to add a trend Arrow (Up, Down or Flat)
What I want to do is trend the previous collected data points performance and visually see if there is an improvement:

i:e Data points could be Months of the yr completed so far


What would be the calculation to trend the data and then how do I change the result to a symbol of an Up, Down Flat arrow

Many Thanks in advance

 

[Caleeco]

I would suggest using a nested IF statement and conditional formatting. The formula depends on how many data points you are using to define a trend?

In it's simplest form, for a month to month comparison the pseudocode would be
IF Cell1 < Cell 2 = -1
IF Cell1 = Cell 2 = 0
IF Cell1 > Cell 2 = 1

Then you can use CF for those 3 results on the cell. (Choosing up/down arrow symbols)

Regards
Caleeco

 

[Jackgeorge]

Thank you for replying

Im not as good on excel as I should ...... so what calculation should go into cell G12, when the current months performance is in E12 and the previous months are stored on a separate Tab "Data1" cells E7 to P7

We now end up with 13 months of data (Jan to Dec 2016 & Jan 2017)

The goal for me is to see the trend over those (In this example 13 months) presented by an arrow in G12, colour coded even better (Green for Up, Red for Down & Amber for flat)


Thanks

I would suggest using a nested IF statement and conditional formatting. The formula depends on how many data points you are using to define a trend?

In it's simplest form, for a month to month comparison the pseudocode would be
IF Cell1 < Cell 2 = -1
IF Cell1 = Cell 2 = 0
IF Cell1 > Cell 2 = 1

Then you can use CF for those 3 results on the cell. (Choosing up/down arrow symbols)

Regards
Caleeco