Controlling a Shape (arrow) based on value

Chris_George 

I think you would need a macro to do that. You could adjust the progress arrow's width by taking the Level shapes left value and subtracting the progress arrows left value. But, you would need to figure out how you want to activate the macro, whether it is attached to a button that you click to update, or if you have the macro run when you input a value into a particular cell, or when the worksheet calculates, etc.

This appears to work (but, it's incomplete as it would still need some logic to decide which level the arrow needs to be adjusted to):

Sub Macro1()
     With Worksheets("Sheet1")
          .Shapes("ProgressArrow").Width = .Shapes("Level1").Left - .Shapes("ProgressArrow").Left
     End With
End Sub