Line Carts

[Jennifer]

I have a line chart that has several series from a table
in it for the source data. I would like one of those
series to be a constant number throughout the graph. (It
would be a strait line on the graph at a given point)
What do I enter in the Values field? When I enter ={500}
it just gives me the first point on the graph as 500, not
a whole line of 500's. Please help!
Thanks,
Jennifer

 

[Debra Dalgleish]

Jon Peltier has instructions on his web siter for adding lines to a chart:

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