Thread: Line from Single Cell

I have created a line chart and (Lot numbers on x axis, values on y) and want also to chart an upper and lower boundry number which would be in cells C6 and C7 respectively. These values can change over time but would always want the present value graphed (i.e. always a horizontal line) How do I get Excel to chart that cell value at every lot number? Thanks in advance.

ChemistB

For example
Lot A 2.6
Lot B 3.2
Lot C 2.7
Lot D 3.1

Lower Boundry 2.5
Upper Boundry 3.5

Well, it's convoluted but it works. I preferred the Error Bar Method that Jon discussed. Thanks Carim

ChemistB