That must have been the problem, but I tried to reformat them as numbers
without decimal points
Thanks a lot

"Jon Peltier" wrote in message
...
John -

Do any of the cells contain non-numeric values, that is, they look like
numbers but are formatted as text?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"JohnH" wrote in message ...

I'm trying to express this data as a simple scatter graph with points. It
is for analysing car sales so I can bid at an auction. Usually when I try
this it makes a scattering of data Price (Y), Km (X).. This time it groups
it around a series of points which is meaningless to me.

There are 30 entries ranging from x 17,000 to 250,000 and (y) 4770 to
7170.

The Series entries are Name A,
=A!$B$3:$B$33
=A!$C$3:$C$33
This is the data:
92000 5470
55655 6470
88060 5020
17000 7170
82000 5920
94000 5570
96000 5600
64000 5570
91292 5720
114000 5020
89401 4770
90900 5470
114000 5270
250000 6470
97000 6520
83135 6420
57000 6570
31040 6420
114000 6120
79060 6670
92000 5470
90200 6620
84062 6620
118000 5470
97000 6520
92751 5170
113000 5570
114000 6020
66406 7120
85000 6320
78177 5870


What's going on here??????
Thanks John