Take the following data to use with Chart Wizard to get a chart:

Distance height
0 5
5 4
8 3
9 6
12 7
13 8


If I highlight all data including column titles, the chart wizard produces
both columns as Series, whereas I want Distance column to be X axis values.
Why is this?

If I delete the column heading 'Distance' and leave that cell blank it works
OK, as it does if 1st column contains dates.

It is annoying when I want to quickly highlight data in a spreadsheet to
produce a chart .

Anybody got any simple solution?

Regards

Phiulip