Reference lines on charts

[doublej41]

I have an Excel sheet that graphs some test data for me. The limits of the data are ± 5%. Is there a way I can add reference lines to my charts to show these limits? Ideally I would like these reference lines to be directed to a cell reference in case the limits change.

Obviously an easy way to do this is to simply create a new data series that will produce a straight line. However, this adds another data series to the legend. Is there a way of doing this without having extra data series' appearing on the legend, or by hiding a particular data series on the legend?

Thanks for any help,
Jonathan

 

[VoG]

You can remove unwanted legend entries like this http://www.andypope.info/charts/deletelegendentry.htm

 

[doublej41]

Perfect - Many thanks VoG!!