Scatter Chart

  • Thread starter Thread starter JSRothbart
  • Start date Start date
J

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?
 
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.
Click to expand...

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
 
Back
Top