Thread: [SOLVED] constant value in a chart

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

koday@processtrends.com


"Renaud_D" <Renaud_D@discussions.microsoft.com> wrote in message
news:75E7BFEF-11E3-4640-B555-E6C9937DA89B@microsoft.com...
> 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
>
> koday@processtrends.com
>
>
> "Renaud_D" <Renaud_D@discussions.microsoft.com> wrote in message
> news:75E7BFEF-11E3-4640-B555-E6C9937DA89B@microsoft.com...
> > 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...
>
>
>