software

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...

Renaud_D

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

processtrends.com/pg_charts_horizontal_line.htm

Kelly

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

Splendid! Worked like a charm. Thanks so much!

Cheers,

Renaud Dainville, Brussels

quot;Kelly O'Dayquot; wrote:

gt; Renaud_D
gt;
gt; This link shows you how to add a horizontal line to your chart.
gt;
gt; processtrends.com/pg_charts_horizontal_line.htm
gt;
gt; Kelly
gt;
gt;
gt;
gt;
gt; quot;Renaud_Dquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt; How can I display a constant value as a line in a chart? For example,
gt; gt; let's
gt; gt; assume that I track a variable x across time with n values. In the
gt; gt; spreadsheet, I calculated the average of the n observations. I'd like to
gt; gt; display this average value as a line in the chart so that it is easy to
gt; gt; visually relate any point in the date serie to this average value.
gt; gt; thanks in advance for any hint...
gt;
gt;
gt;

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

quot;Kelly O'Dayquot; wrote:

gt; Renaud_D
gt;
gt; This link shows you how to add a horizontal line to your chart.
gt;
gt; processtrends.com/pg_charts_horizontal_line.htm
gt;
gt; Kelly
gt;
gt;
gt;
gt;
gt; quot;Renaud_Dquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt; How can I display a constant value as a line in a chart? For example,
gt; gt; let's
gt; gt; assume that I track a variable x across time with n values. In the
gt; gt; spreadsheet, I calculated the average of the n observations. I'd like to
gt; gt; display this average value as a line in the chart so that it is easy to
gt; gt; visually relate any point in the date serie to this average value.
gt; gt; thanks in advance for any hint...
gt;
gt;
gt;

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:

peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
peltiertech.com/
Andy_jm wrote:
gt; I just tried this and there was no line ... do you have any other pointers?
gt;
gt; quot;Kelly O'Dayquot; wrote:
gt;
gt;gt; Renaud_D
gt;gt;
gt;gt; This link shows you how to add a horizontal line to your chart.
gt;gt;
gt;gt; processtrends.com/pg_charts_horizontal_line.htm
gt;gt;
gt;gt; Kelly
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Renaud_Dquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Hello,
gt;gt;gt; How can I display a constant value as a line in a chart? For example,
gt;gt;gt; let's
gt;gt;gt; assume that I track a variable x across time with n values. In the
gt;gt;gt; spreadsheet, I calculated the average of the n observations. I'd like to
gt;gt;gt; display this average value as a line in the chart so that it is easy to
gt;gt;gt; visually relate any point in the date serie to this average value.
gt;gt;gt; thanks in advance for any hint...
gt;gt;
gt;gt;