Upper limit and lower limit in excel line charts

Question

hi,

how do u plot upper limit and lower limit in a line chart? i am using a dynamic range in that chart(using offset function). i tried plotting the limits as a line chart but that doesnt work for my case. for example say -2 to +2 is my limits. i wont be able to enter the limits each and everytime when my user records data but if i enter my limits as -2 to +2, that chart should show up a flat line in the chart at -2 and +2.

note : i have to enter the limits only once and the user should be able to change the limits

Answer 1

Have a look at http://peltiertech.com/Excel/Charts/AddLineHorzSeries.html

My attempt is shown in screenshot

best wishes