• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • 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
 
pdvsaAuthor 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
 
pdvsaAuthor 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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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