Static lines

[Peter B]

Hi,

How do I make a static line that will always be for
example 2. I have tried to put it 2 as the values in a
new series, but are only getting the value at the start
of the chart.

Peter

 

[Debra Dalgleish]

Jon Peltier has instructions for adding lines to a chart:

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine