Scatter Chart

[JSRothbart]

I am trying to create a scatter chart where I have two sets of values,
one on the X axis and the other on the Y axis and then a signle data
point is plotted that corresponds to both values.

Everytime I have tried to make the chart, I only get one value being
plotted (on the Y axis) and the X axis is not relevant. I cannot get
these to plot correctly.

Can anyone help?

 

[Bruce Sinclair]

I am trying to create a scatter chart where I have two sets of values,
one on the X axis and the other on the Y axis and then a signle data
point is plotted that corresponds to both values.
Everytime I have tried to make the chart, I only get one value being
plotted (on the Y axis) and the X axis is not relevant. I cannot get
these to plot correctly.

Well, it seems to me that if you have 2 columns of numbers, then you can use
those as X and Y in the chart without any more info. That XY pair uniquely
defines the point to plot - no more info is needed.

Check it is indeed a scatter plot and not one of the many XL chart types
that use 'category' variables (which space evenly along the bottom using
the numbers as 'labels' rather than using the values as data. ). That is
a serious and IME, undocumented 'feature' that traps many players, not just
the young.

HTH