Goeff,
I wouldn't draw the same conclusion about Numbers as you do. If you select your first column and format it as Text, either using the Cells Inspector or the Format Bar, then select the entire three columns and Add a Chart, the chart will use the first column as the Category axis labels and the last two columns as Value Axes data. And, you will have a Category Chart, not well suited to plotting functions.
Numbers Charts are not up to heavy duty scientific work, but they do work pretty much as advertised. By the way, for your case, you should be using a Scatter Plot, in which case Numbers will accept (demand actually) that the first column be formatted as numeric. No, you can't get lines between the points of a Scatter Plot, but that's another issue.
Thanks for your questions.
Regards,
Jerry