• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Graph Ratings (not numbers)

Experts,

I am not certain if debt ratings can be graphed (ie letters...not numbers)
I have attached a db in 2007 format.
The query is what I would like to graph but I dont think letters will plot.

Maybe there is some trick to this.  

thank you
RatingTEST.accdb
0
pdvsa
Asked:
pdvsa
  • 2
  • 2
2 Solutions
 
als315Commented:
You can't draw characters, but you can add table, where to characters will be assigned some digital rating. You can do it yourself or take here:
http://en.wikipedia.org/wiki/Bond_credit_rating
Look at sample (open your query as PivotChart)
RatingTEST.accdb
0
 
pdvsaProject financeAuthor Commented:
Ok I opened the query as pivot chart.  I see you added 2 columns (MoodyDigital: 22-[tblRatingsAll_1].[ID] and SPDigital: 22-[tblRatingsAll].[ID].  Am i suppose to see the letter ratings (AAA, BBB, etc etc) along the Y axis or is your comment "you cant draw characters" meaning you cant plot letters on the Y axis?   thank you for the help.
0
 
als315Commented:
I don't know how you can show letter ratings on Y axis. May be only if you place pivot chart upon some grid with these letter ratings.
Seems it is possible in excel:
http://peltiertech.com/WordPress/text-labels-on-vertical-axis-in-excel-column-chart/
but it is not so simple
0
 
pdvsaProject financeAuthor Commented:
OK.  I have heard that excel 2013 might be able to label the X axis better but maybe not the Y axis. Seems like the Y axis must be numbers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now