In a line graph, how do I put in an automatic reference line, going back from my last entered point?

[DN123ABC]

Here is some sample data:
Date Rate 30 years APR 30 years Rate 20 years APR 20 years Rate 15 years APR 15 years Rate 10 years APR 10 years
8/11/2014 4.125 4.200 3.875 3.977 3.125 3.217 3.000 3.134
9/11/2014 4.125 4.200 3.875 3.977 3.250 3.343 3.000 3.134
9/18/2014 4.250 4.325 4.000 4.103 3.375 3.468 3.125 3.259
9/30/2014 4.125 4.200 3.875 3.977 3.375 3.468 3.000 3.134
10/2/2014 4.125 4.200 3.875 3.977 3.250 3.343 3.000 3.134
10/8/2014 4.125 4.200 3.750 3.852 3.125 3.217 3.000 3.134
10/13/2014 4.000 4.074 3.750 3.852 3.125 3.217 3.000 3.134
10/14/2014 4.000 4.074 3.625 3.726 3.000 3.092 2.875 3.009
10/16/2014 3.875 3.949 3.625 3.726 3.000 3.092 2.875 3.009
10/21/2014 3.875 3.949 3.750 3.852 3.000 3.092 2.875 3.009
10/29/2014 4.000 4.074 3.750 3.852 3.125 3.217 3.000 3.134
12/2/2014 3.875 3.949 3.750 3.852 3.125 3.217 3.000 3.134
1/8/2015 3.625 3.697 3.500 3.601 3.000 3.092 2.875 3.009
1/20/2015 3.625 3.697 3.500 3.601 2.875 2.967 2.875 3.009
2/10/2015 3.625 3.697 3.500 3.601 2.875 2.967 2.750 2.883

I want a line to go from the 2.883, back to the left across the graph, to see how the latest number compares to all previous.

Thanks.

[DN123ABC]

Is it possible to add a screen-shot?

I tried adding a new column, with that column=last entry all the way down, but could not overlay the line over the bars. I also tried trendline, but that didn’t work; and neither were “automatic”.

I just want a line back across all the past data, to compare where the current one is in relation.

[Zeca]

there you go, take some Karma so you can upload the screenshot!