If the first column contains text information, select any cell in the range
you want charted, then click the Chart Wizard button. XL should use the
first column as the x-axis values.

If it doesn't you have two choices. Either delete the header of the first
column, then follow the steps in the previous paragraph or in the 2nd step of
the chart wizard click the Series tab and then set the first column as the
Category (X) values.

--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"Richard Erlacher" wrote:

I wish to limit my chart to only the data I entered into the spreadsheet.
How can I suppress the use of the row numbers as the x-axis on a line chart?

I want the leftmost selected column to be my horizontal axis, relative to
which every other column is displayed. I also need to control the scale of
the vertical axis, but "help" doesn't help with that either.

How can I do this?

Richard