Adding custom Line in XL CHart

[saturnin02]

Hi,
I am trying to add a horizontal line to a chart in XL 2002 WIN XP at "0".
The Y axis goes from -50,000 to 1,500,000 but does not mark "0".
I would like to add a red horizontal line to the chart to clearly mark the
"0" level.
I can't figure out how to do this.
Any ideas?
Tx,
Sat

 

[saturnin02]

I'll try adding a series with 0 I guess.
I've tried the other wyas before but just cdn't get it just right.
Tx Richard.

 

[Debra Dalgleish]

Jon Peltier has instructions for adding a Horizontal Line to a chart:


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