I'm building a stacked line chart.
 

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?

I'm building a stacked line chart.
 

You probably want a regular line chart for this, not a stacked line chart,
which adds each series' values to the previous series' values.

Also, you should not worry so much about cluttering the worksheet with data
to be plotted. There are ways to make a line without using so many cells,
but you have to complicate the chart in other ways:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ron" wrote in message
...
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?