Hi again mhagerman,
I'm not sure if this is what you were referring to in your second paragraph, but in case it isn't I'll offer it up. You could use worksheet formulas to translate the non-numeric data into numeric data in another area of the worksheet or in another worksheet, then chart the numeric data. This way, the numeric data need not even be visible.
Damon