Stacked column with dollar data but adding horizontal line that is a %

Hi All,

I have been reading on the forum and other videos and such and I can't seem to make this work. I have attached a file for explanation purposes. I am having trouble getting the threshold line (in this case a horizontal line at the 50% marker) to display as part of my data set In all the examples I have looked at the threshold line is always the same format as the source data, eg, dollars and dollars or % and %. In my case what I am attempting to show with the data is if the proposed value is greater than 50% of the total of each stacked column (or visually falls below the below the 50% line) then that means it cost us more than we originally planned and vice versa.

Any step by step help on the right way to accomplish this would be GREATLY appreciated.

Thanks,

Chris