X axis wrong

[Underpants]

Price Km
10900 47759
10900 47759
1000 117000
4950 145747
10000 114000
9000 96250
2550 130000
9500 127000
6950 93000
4995 154000
5000 129000
8990 70000
12000 151000


I'm trying to make this data into a scattergram but I can't get the x
axis (Km) to the correct range (up to 160000). The first one I did
(following instructions worked perfectly, any ideas?
Thanks
U

 

[JohnH]

Apparently the X axis is now the number of the row. I want it to show the
data value of the (other) column. I'm trying to create a way of comparing
car prices....
U

 

[Roger Govier]

Hi

Just marking the complete range of data in both columns, clicking on the
chart icon, selecting Scatter graph and Finish produces a chart for me
with Price going from 0 to 14,000 and Kilometres rising from 0 to
180,000

 

[Underpants]

For some reason it doesn't work for me for that data but does for this:
KM Price
50,770 12,999
6,500 21500
105,235 10,400
68,002 11,995
49,529 12,999
84,000 9,600
39,237 12,999
95,231 10,200
97,685 10,600