I'm building a stacked line chart, with three lines: minimum acceptable
value, maximim acceptable value, and measured value. For all values along
the x-axis, the min and max are the same (horizontal line). If I use a
single cell for the max or min value, the chart builder only plots one point,
instead of a point for each x in the domain. I can copy the max and min
values to a range of cells, and it displays fine, but that clutters up my
worksheet.

Is there a way to assign a constant value to the range, for the whole
domain, without copying a set value to several cells in the worksheet?