A few formulas will fix the data for you. Columns A and B contain your original data. Columns C thru F have formulas in these cells, copied down as far as needed:

C2: =RANK(A2,A$2:A$12,1)+COUNTIF(A$2:A2,A2)-1

D2: (not formulas, just values 1, 2, 3, etc.)

E2: =INDEX(A$2:A$12,MATCH($D2,$C$2:$C$12,0))

F2: =INDEX(B$2:B$12,MATCH($D2,$C$2:$C$12,0))

Just plot columns E and F in your chart.

If you have the new **Dynamic Arrays**, it's even easier. Columns A and B have the original data. These formulas are only entered into the indicated cells, and they fill values down automagically:

C2: =SORT(A2:A12)

D2: =SORTBY(B2:B12,A2:A12)