Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart / Graph
Hello,
I would like to add threshold lines (horizontal lines) in a chart to show maximum and minimum values. In algebra the equations would be for instance y=100 for the max and y=55 for the minimum. How can I do this without having to repeat the same values indefinitely in the table or in the "=series" statement of the graph (repeated values being in my example 100 for the max and 55 for the min.). Thank you. Eric. |
#2
|
|||
|
|||
Jon Peltier has instructions for adding a horizontal line to a chart:
http://www.peltiertech.com/Excel/Cha...s.html#AddLine Eric wrote: I would like to add threshold lines (horizontal lines) in a chart to show maximum and minimum values. In algebra the equations would be for instance y=100 for the max and y=55 for the minimum. How can I do this without having to repeat the same values indefinitely in the table or in the "=series" statement of the graph (repeated values being in my example 100 for the max and 55 for the min.). -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Great, thank you.
Eric. "Debra Dalgleish" wrote in message ... Jon Peltier has instructions for adding a horizontal line to a chart: http://www.peltiertech.com/Excel/Cha...s.html#AddLine Eric wrote: I would like to add threshold lines (horizontal lines) in a chart to show maximum and minimum values. In algebra the equations would be for instance y=100 for the max and y=55 for the minimum. How can I do this without having to repeat the same values indefinitely in the table or in the "=series" statement of the graph (repeated values being in my example 100 for the max and 55 for the min.). -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combination chart (different graph types) | Charts and Charting in Excel | |||
Chart formatting | Charts and Charting in Excel | |||
bar, line and cumulative bar graph in one chart | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |