Stacked column query|Dashboards & Charts|Excel Forum|My Online Training Hub

Hi, I'm new here having just bought the premium course so thanks in advance for any help and support. 

I recently watched  Mynda's youtube video on gauge charts where she recommended using a single stacked column at the end. 

Create a regular column chart>switch the data series>columns then stack. 

Insert a line marker for the nominated value>select the dash symbol>increase size to width of column.

My problem is that I want the marker to shift as the cell value changes either manually or via slicer. However when I do this the line always reverts back to the standard dot marker which then has to be resized and reformatted etc.

Any ideas if it's possible to do?