Three columns of data
first column - names of countries
second column - credit ratings of countries eg AAA; AA; A
third column - values
Perhaps this isn't possible
but I want the x Axis to be the credit ratings of countries, and the y axis to be the value. And then for each country to plot a dot which co-ordinates with its credit rating and value.
I think this is what you were looking to do. If not let me know.
hiya, thanks for your post.
No not quite. I think what I do need is a scatter plot as there are two variables here. one is the credit rating, the other is the value. I want to show a relationship between the two, that a certain credit rating will give a particular value I guess.
and next to the dot thats been plotted would be annotated the particular country.
Create a column chart on some dummy data in order to get the credit rating category axis.
The add a series and change that to xy-scatter.
Set the data source for xy-scatter series to be your Credit rating/Value cells.
Finally link data labels to cells to get country name next to marker.
http://www.appspro.com/Utilities/ChartLabeler.htm
Thanks for your chart-its exactly what I am looking for.
I'm having trouble replicating it though. Whenever I change it do do a scatter plot, it changes the a-axis labels from AAA, AA , A to 1, 2, 3
I've done that bit now but because I have more than one entry with AAA rating, the A axis is displaying AAA twice.
Last edited by chedges; 03-17-2009 at 06:34 AM.
can you post your workbook.
Bear in mind to get textual labling of the X axis you need to have a combination chart of Column and XY-Scatter
Sure thanks.
I've left the column chart in as when i delete it thats when the problem occurs.
at present though with the column chart in there, the values are corresponding to the releveant credit ratings.
In the first file the rating where actually values, 1 2 and 3 with custom number formats to display A AA and AAA
Now the A's are just text and are there fore treated as categories.
Somewhere in your workbook you need to convert the credit rating text to a X value.
Sorry in my last post i meant "the values AREN'T corresponding to the releveant credit ratings"
Ok what you say makes sense, but i've never done that before so I dont know how to covert them. Would I need to type in place of the credit ratings 1, 2, 3 etc and then custom format it? How do I convert into an X value.
Tks
You need a lookup table to allocate a X value to a credit rating.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks