Scoring meter

Luigi802

New member
Joined
Aug 29, 2016
Messages
12
Reaction score
0
Points
0
Excel Version(s)
2016
OK, so I'm trying to create a scoring meter similar to the 1 attached; but, I want the right side (Green) to get smaller while the left side (Red) gets bigger.
Here are example parameters I'd like to use:
Goal spending amount $150 (Full scale)
Amount spent so far $50 (Red side, Left) Also pointerView attachment Scoring Widget.xlsx
Remaining amount $100 (Green side, Right)
ALL VALUES MUST BE VARIABLE!

So as my spending goes up the pointer moves accordingly and the red gets bigger as the green gets smaller......does that make sense?
 
Back
Top