Insert Drawing Tool "Arrow"

[canthony24]

So I have worksheet that has a few charts, and on the top of each chart is a 3 year CAGR % surrounded by a circle that is just drawn on. Behind the circle, is a drawn arrow that is pointing "UP", but I want to make it so that if the 3 year % is negative, the arrow would automatically point down. I know I can use conditional formatting, but it's not how the "management team" wants to see it.

Ideas?

This is the picture below. If the % is positive, automatically insert an arrow UP, and negative DOWN

[/IMG]

 

[canthony24]

Bump

 

[canthony24]

Still looking into this. Haven't found a solution yet.