buble graph x axis putting values in order rather than using value

[Khornight]

Ok I have a bubble graph, works fine once it's working. But i'm changing the data (coping from another workbook and pasting) and sometimes (no pattern as to when yet) it stops treating the x values as it should and instead puts them in the order they appear in the list.

Eg with the following data:

X	Y	Bubble Size
1	3.5	1000
1.75	2.3	2250
1.80	15	5500
15	35	17500

<tbody>
</tbody>

The four points get evenly spaced along the x axis, with the top row first (so effectively the same as x being 1,2,3,4)... with some random swapping of values it starts to work again! But not sure what is causing it or how to fix it, any suggestions?

Thanks

 

[Jon Peltier]

If any of the X values are not recognized by Excel as numerical, Excel will instead default to plotting them as 1, 2, 3, etc.