Drawing a line on a sheet based off cell value

Hello,

So I am trying to plot a line on a user designed graph depending on a cell's value. I did not use the chart wizard to do this because I have to use the user designed graph. So it would be like a median or average line if I was using the chart wizard.

I have included what the file and based off the value in AG36 is where the orange line is needed.

So I know Vba will draw a line with a statement like Call DrawArrows(Range("B25"), range("AF25"), RGB(0,0,255), "Line")

Any ideas will be helpful.

LeapingLizard

Hello
Maybe a Conditional Formatting formula applied to B2:AF28:

Formula:

Please Login or Register  to view this content.

Format the fill to required colour.

DBY

Hello DBY,

This worked as it just highlighted the cells. Was looking for code that would input a line. I just don't know how to have this statement; Call DrawArrows(Range("B25"), range("AF25"), RGB(0,0,255), "Line") call the ranges out as the could change each time. I appreciate the thought. Any other suggestions would be appreciated.

LeapingLizard

Sorry I misunderstood. I don't know about the 'DrawArrows' call but try the following VBA code on the Worksheet Calculate Event:

Please Login or Register  to view this content.

Does this do as you require?

Super! Your help is greatly appreciated.

Glad to have helped. Thank you for the feedback.

Hello DBY,

It worked, but did not plot in the proper location. Plus, when does this sub routine run? I have included the updated file and you will be able to see the discrepancy. Thanks!

LeapingLizard