plotting location of a number within a range

  • Thread starter Thread starter Steve Winters
  • Start date Start date
S

Steve Winters

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
 
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
 
Back
Top