Hello -

I have tried to find a solution to this (without using an add-in), but have
been unable.

Suppose we have values like this:
Time Rating Symbol
T1 Aaa
T2 Aa2
T3 Aa3
T4 Ba1
T5 Ba1
T6 Ba1
T7 B2
T8 Caa2
T9 Caa3
T10 Caa3
T11 C
T12 C

The problem is that Excel does not seem to understand how to rank the
ratings.

One nice way of doing this wopuld be to replace the ratings with numerical
values and then in the chart somehow replace the numerical values with the
corresponding ratings text.

This sems likea pretty difficult problem. If anyone has any insights i
would greatly appreciate it.

Best Regards,

Chris )