Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scatter chart not plotting correct range | Charts and Charting in Excel | |||
Scientific plotting, non-zero x-axis origin, and number labeling | Charts and Charting in Excel | |||
Location of n-th highest value in the range | Excel Discussion (Misc queries) | |||
Set a range from a variable location | Excel Discussion (Misc queries) | |||
Not plotting blank cells with formulas until number appears | Charts and Charting in Excel |