Hi,
There are various ways of addressing this problem.
See the following for examples of adding lines to charts.
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
Cheers
Andy
Cygnusx1 wrote:
I have a chart that is XY (scatter) that I need to put limit lines on. I want
to put a colored line at 1% and -1%. Can this be done?
Thanks
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info