In D1:D10 enter the text A, B, C, .... J
In E1 enter =MAX(IF(A:A=D1,B:B))-MIN(IF(A:A=D1,B:B))
but commit it with SHIFT+CTRL+ENTER as it is an array formula (Excel will
enclose it in braces { } )
Copy this down to E10
Make chart using D1:J10 for you data
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"easymac" wrote in message
...
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