Solved

Graph Ratings (not numbers)

Posted on 2013-06-01
4
286 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
  • 2
  • 2
4 Comments
 
LVL 39

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 39

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

831 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