Solved

Graph Ratings (not numbers)

Posted on 2013-06-01
4
303 Views
Last Modified: 2013-06-02
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
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 39213859
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
 

Author Comment

by:pdvsa
ID: 39214595
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
 
LVL 40

Assisted Solution

by:als315
als315 earned 500 total points
ID: 39214755
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
 

Author Closing Comment

by:pdvsa
ID: 39215170
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question