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.

http://processtrends.com/pg_charts_horizontal_line.htm

Kelly

(E-Mail Removed)


"Renaud_D" <(E-Mail Removed)> wrote in message
news:75E7BFEF-11E3-4640-B555-(E-Mail Removed)...
> 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...

Hello Kelly,

Splendid! Worked like a charm. Thanks so much!

Cheers,

Renaud Dainville, Brussels

"Kelly O'Day" wrote:

> 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 Removed)
>
>
> "Renaud_D" <(E-Mail Removed)> wrote in message
> news:75E7BFEF-11E3-4640-B555-(E-Mail Removed)...
> > 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...
>
>
>

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

"Kelly O'Day" wrote:

> 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 Removed)
>
>
> "Renaud_D" <(E-Mail Removed)> wrote in message
> news:75E7BFEF-11E3-4640-B555-(E-Mail Removed)...
> > 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...
>
>
>

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Andy_jm wrote:
> I just tried this and there was no line ... do you have any other pointers?
>
> "Kelly O'Day" wrote:
>
>> 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 Removed)
>>
>>
>> "Renaud_D" <(E-Mail Removed)> wrote in message
>> news:75E7BFEF-11E3-4640-B555-(E-Mail Removed)...
>>> 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...
>>
>>