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:
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]X[/TD]
[TD]Y[/TD]
[TD]Bubble Size[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]3.5[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]1.75[/TD]
[TD]2.3[/TD]
[TD]2250[/TD]
[/TR]
[TR]
[TD]1.80[/TD]
[TD]15[/TD]
[TD]5500[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]35[/TD]
[TD]17500[/TD]
[/TR]
</tbody>[/TABLE]

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.