Relative comparison of non-numerical & graphing

[sampahmel]

Hi all,

I have 2 questions:

I am given credit ratings of several companies.

(1.) I would like to graph them, with both the X- and Y-axes displaying alphabets.

(2.) Given 2 companies (Company 1 and 2) each with 2 ratings given by different parties (for example, Party A and B). If Party A shows that Company 1 is stronger than Company 2, I would like to check if Party B's rating is showing the same relative relationship (i.e. Company 1 is > Company 2)?

Please see my spreadsheet as attached.

Thank you for reading and helping to solve these.