I'm building a stacked line chart.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ron - 23 Jan 2008 14:59 GMT

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?

Reply to this Message

Jon Peltier - 23 Jan 2008 20:49 GMT

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
_______

> I'm building a stacked line chart, with three lines: minimum acceptable
> value, maximim acceptable value, and measured value. For all values along
[quoted text clipped - 7 lines]
> 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?

Reply to this Message