Charts with text on y axis
Is there a way that i can chart data using text ratings? My data has a rating for each week according to performance ie good, average, bad. I am hoping that i can have the x axis as a week number and then the y axis be a representation of the ratings.
Is there a way to do this other than having the ratings be converted to a number in a calculation field ie good =3, average = 2 etc and have that charted?
Many thanks for any assistance?