I am creating a chart based off of query values. One column is of letters, i.e. A,B,C,D, etc.
The problem I am running into is trying to graph those values. If a student receive a 'B' I'd like the column chart to reflect that on the y axis. So y axis would have from the bottom A to G for example. The x axis has student name. I can do this if the some how the LETTERS were numbers then I could represent numeric value on the y axis (of course not sure how I could create the ALPHA labels on the y-axis.
Does anyone have any experience with this?