Goal Line in Bar Graph - Can't get it to work

Please see attached excel file for example,

I currently have a line (drawing object) which shows the goal line for my bar graph. In the attached file, the goal is 84.99%. This is a variable and I have to manually move the bar as this goal changes. I have multiple graphs and this is very time consuming. I have tried methods found here:

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

But most of them are for scatter type graphing data, and the methods that are not, just dont seem to work for the chart type I am using. I think my only option is to use vba to move the bar based on a value, please let me know if you can help.