Simple solution, as you've found, is to leave the X axis column heading
blank until after you've produced your chart, and then fill it in.
--
David Biddulph

"Philip Reece-Heal" wrote in message
...
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