Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
constant value in a chart
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" wrote in message ... 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... |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
constant value in a chart
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 "Renaud_D" wrote in message ... 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... |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
constant value in a chart
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 "Renaud_D" wrote in message ... 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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |