plotting location of a number within a range
 

Hi,
I'm trying to create a chart showing where a number falls within a
range. For example, given the following:

Number Min Median Max
110 90 105 120

What I would like to do is plot a bar something like this:

|============||=*==========|
90 105 120

there the * on this chart indicates the "Number" field. I have tried a
variety of things without success. All suggestions welcome.
Thanks.

Steve

plotting location of a number within a range
 

Steve, you can probably achieve what you are trying to do by plotting the
numbers as points with no lines joining them, then click on the series,
select Format, Selected data series, then use x error bars to form the span
of highs and lows comprising the range of values you seek.

On your spreadsheet, define these "errors" by creating a column containing a
calc for Max - Number, and one for Number - Min and that will define the
length to the left and right of the number.

For the median, I'd just plot another point.

Hope this helps. Brad


"Steve Winters" wrote in message
oups.com...
Hi,
I'm trying to create a chart showing where a number falls within a
range. For example, given the following:

Number Min Median Max
110 90 105 120

What I would like to do is plot a bar something like this:

|============||=*==========|
90 105 120

there the * on this chart indicates the "Number" field. I have tried a
variety of things without success. All suggestions welcome.
Thanks.

Steve