Graphing Non-numeric data on a bar chart - XL 2003 pro. ed.

[nishant607]

I'm trying to show alpha-numeric values as a bar/column chart.

Problem background:
Objective: to combine numeric data on ane axis, and alpha-numeric data on the second axis.

Example: Show the overal gpa on one axis and letter grades in a particular subject (eg. Math) over a number of years (2000 to 2004) on the x-axis.

Thanks.

 

[fairwinds]

Hi,

not sure I understand what you want, however I believe you somehow need to translate your alpha-numeric's in to numbers in order to be able to plot them in a chart.

Some examples maybe?