Scatter Chart


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?
 
Ad

Advertisements

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top