Hi, everyone. I need a quick tip as to how to do this "XY Scatter chart". I'm trying to do a graph showing the credit rating of a firm over the years. So on the Y axis, I want to have letter grid with AAA on the top followed by AAA-, BBB+, BBB, BBB-, etc. then, I want the Y-axis to cross the X axis (year) between BBB- and BB+, followed by BB, BB-, etc...
I have graphed by using the XY Scatter chart. How would I make the Y-axis appear the letter grid I wanted instead of numbers? (somehow, even though I selected the Y-Axis to be the letter grid as described above, somehow the chart converted the letters to a number). Also How could I make the Y axis and X axis intersect at the middle of BBB - and BB+?
Thank you very much!!
I have graphed by using the XY Scatter chart. How would I make the Y-axis appear the letter grid I wanted instead of numbers? (somehow, even though I selected the Y-Axis to be the letter grid as described above, somehow the chart converted the letters to a number). Also How could I make the Y axis and X axis intersect at the middle of BBB - and BB+?
Thank you very much!!
