constant value in a chart
in [Charts]
|
Prev: Formatting a 4 Series Stock Chart
Next: A Challenging Charting Qustion - Are there any Brainiacs Among
From: Andy_jm on 25 Nov 2009 05:06 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 > > koday(a)processtrends.com > > > "Renaud_D" <Renaud_D(a)discussions.microsoft.com> wrote in message > news:75E7BFEF-11E3-4640-B555-E6C9937DA89B(a)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... > > >
From: Jon Peltier on 28 Nov 2009 13:33
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 >> >> koday(a)processtrends.com >> >> >> "Renaud_D" <Renaud_D(a)discussions.microsoft.com> wrote in message >> news:75E7BFEF-11E3-4640-B555-E6C9937DA89B(a)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... >> >> |