constant value in a chart

[Guest]

Hello,
How can I display a constant value as a line in a chart? For example, let's
assume that I track a variable x across time with n values. In the
spreadsheet, I calculated the average of the n observations. I'd like to
display this average value as a line in the chart so that it is easy to
visually relate any point in the date serie to this average value.
thanks in advance for any hint...

 

[Kelly O'Day]

Renaud_D

This link shows you how to add a horizontal line to your chart.

http://processtrends.com/pg_charts_horizontal_line.htm

Kelly

(e-mail address removed)

 

[Guest]

Hello Kelly,

Splendid! Worked like a charm. Thanks so much!

Cheers,

Renaud Dainville, Brussels

 

[Andy_jm]

I just tried this and there was no line ... do you have any other pointers?

 

[Jon Peltier]

You may have to format this added series so the markers don't show but
the lines do. Or perhaps seeing the technique explained differently may
help:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon