Hi,

If I understand you question correctly you want to display a single bar that
spans for the min to the max.

You can start with some of the previous suggestion:
Suppose you have you letters in A2:A12 and the values in B2:B12, then in
D2:D4 enter you letters
A
B
C

in cell E2 array enter

=MAX(IF(A$2:A$12=D2,$B$2:$B$12))

in cell F2 array enter

=MIN(IF(A$2:A$12=D2,$B$2:$B$12))

Copy both these formulas down and then plot the data.

Now, double click the series on the chart and choose the Options tab, and
set the Overlap to 100
--
Thanks,
Shane Devenshire


"easymac" wrote:

Hi, everyone.

Let's say I have two columns. Column A has the first ten letters of the
alphabet, each listed 4 times (A1=A, A2=A, A3=A, A4=A, A5=B, A6=B, etc), and
in column B there are, let's say, random numbers between -10 and 10. I want
to create a chart that will graph the range using the maximum and minimum
values for each letter in column A. This would of course be a one-axis graph
(graphing only the values in B on the x-axis with the different values in A
being placed on top of (or to the side) of each other.

Any suggestions?

Thanks,
Bobby