• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Add arrow in excel chart at update point

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
 

Attachments

  • 2015 SHP Results analyser.xlsx
    115.5 KB · Views: 5
How do think to control a Macro? What makes it run?
... for all other charts, check an idea from photo, not necessary need macro.
 

Attachments

  • SHP.png
    SHP.png
    44.4 KB · Views: 13
Back
Top