Adding a specific constant value line to chart

Originally Posted by harryg

I am producing a chart for the year broken down by month and values from 70 - 100 in incriments of 5. I would like to add a line somewhere between 80 - 85 for a specific value that remains constant throught out the year, how is this done. Thanks

Hi,

normally done with a second series, usually a different colour from the main series.

http://www.andypope.info/charts/averageline.htm has a great example

hth
---