Adding target or goal line to excel chart

[sandia]

Hello All,


I am trying to add a Target line to excel chart following Peltier & Chandoo's forum Exercises. I am stuck at extending the target line to span the entire chart and adding just a data point marker at the end of the target line.


Using Excel 2007


http://peltiertech.com/WordPress/add-a-target-line/

 

[sandia]

This is the sample data for the above question.

 

[sandia]

https://docs.google.com/spreadsheet/ccc?key=0Ag5u3i0f8rz_dDg0eThIb0FTOHJpM0o2TmVsZHZBVFE&hl=en_US#gid=0