Type this into the EXCEL 2007 F1 key help facility:-

Present Your Data In A Scatter Chart Or A Line Chart

I think that the above may help.

The above topic covers in detail the construction of the X axis for a
Scatter (XY) Chart.

"confusedgeo" wrote:

I am using a XY chart, not a line chart. However, it shouldn't make any
difference because all I need to do is plot Cartesian coordinates with the
x-y values in separate columns. A line chart would still have to get the x
values from someplace.

Example:

Column 1 Column 2
.0023 .14

I need the coordinates to be (x,y) (.0023, .14)

As it stands, Excel is charting each data point in a sequence it has chosen
with the first data point at x=1 and the last data point x=3763.

I have 3763 data points total and my max range on the x-axis should be below
1.0


"David Biddulph" wrote:

What type of chart? Are you using a line chart instead of XY?
--
David Biddulph

"confusedgeo" wrote in message
...
I am having some trouble getting Excel 2007 to chart two columns versus one
another. All I need is for the value in the first column to be the x
value
and the second column to be the y value. Excel disagrees with this and
keeps
plotting the *cell number* on the x-axis. I have been trying figure this
out
and cannot for the life of me figure it out.

I would appreciate any insight on this issue.


.