Add arrow in excel chart at update point

[FaizanRoshan88]

Hi, I need some help in excel Vba code.
when user types in data, the chart updates. But then a macro must add an Arrow on the last chart entry to show Up arrow or Down Arrow to highlight latest trend
Some Object insertion with text depending on formula in first chart
- Eg. If HEPS in chart 1 is lower than consensus, Banner shape must state “Miss consensus”. If higher, then “Beat consensus”. If within 2% of consensus, then “In Line”
- For all other charts, a directional arrow for the last period (upwards, downwards, flat), colour coded if possible (green = up, red = down).
Advance Thank you for help

 

[vletm]

How do think to control a Macro? What makes it run?
... for all other charts, check an idea from photo, not necessary need macro.