Thermometer graph issue

Hello

Please see attached workbook. i have a thermometer graph, which is causing some issues.


i have three basic fields
actual
goal
%

basically, i would like the % to show (which it is) and the actual and goal on the graph (which they are).

the issue is, i have tried re-aligning or changing the order of the series, but cant get the % to line up with the "actual"

so I would like the "Goal" i.e to be 200,000
if the actual is at 180,000
that would be 90%

so i would like the 90% and 180,000 to be colored the same color.

currently that is now occuring and ive been at this for the past day+.

can someone pls help with the logic!