Graph Question

[Guest]

I have a set of data I want to graph in a specific way. The data consists of
a high value and a low value for each item on the X-axis, the high and low
for each makes up a range. Iwould like to have that range graphed as a solid
bar (vertically). Then, I would like to have a separtate value for each item
plotted against the range for each particular item. The purpose for this
graph is to view whether the value for each item falls within the desired
range. The ranges and valued are different for each item on the x-axis.
Does anyone have any ideas how to do this?
thanks

 

[Guest]

Hi,

Let's suppose that the items are in Column A (say A2:A11), the low and high
values are in Columns B and C (B2:B11 and C2:C11) respectively, and the
values for the items in Column D (D211). Create a new column (say E2:E11)
containing the difference between the High and Low for each item (i.e., in
E2 enter the formula "=C2-B2" and autofill down to E11)

Now make a Line Plot of B2:B11 versus A2:A11. Format the data-series as
follows:
In the "Patterns" Tab, check "None" for "Line" and "None" for "Maker";
In the "Y Error Bars" Tab, select "Plus" under "Display", and under "Error
amount" check "Custom" and for "+" select the range "E2:E11" --> "OK". Now
right-click on one of the vertical bars --> "Format Error Bars" --> in the
"Patterns" Tab select the second pattern for the "Marker" --> "OK"

Now add a second series to the graph with D211 versus A2:A11.

Regards,
B. R. Ramachandran