Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
constant value in a chart
0 views
Skip to first unread message
Renaud_D
Apr 16, 2006, 12:04:01 PM4/16/06
to
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...
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
Apr 16, 2006, 1:11:40 PM4/16/06
to
Renaud_D
This link shows you how to add a horizontal line to your chart.
http://processtrends.com/pg_charts_horizontal_line.htm
Kelly
"Renaud_D" <Rena...@discussions.microsoft.com> wrote in message
news:75E7BFEF-11E3-4640...@microsoft.com...
Renaud_D
Apr 16, 2006, 4:30:01 PM4/16/06
to
Hello Kelly,
Splendid! Worked like a charm. Thanks so much!
Cheers,
Renaud Dainville, Brussels
Andy_jm
Nov 25, 2009, 5:06:10 AM11/25/09
to
I just tried this and there was no line ... do you have any other pointers?
Jon Peltier
Nov 28, 2009, 1:33:16 PM11/28/09
to
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:
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/
0 new messages