scatter plot problem

  • Thread starter Thread starter seferiad
  • Start date Start date
S

seferiad

I'm using XL/Win 2000 and have the following problem with scatter plot.
Column Y is plotted with the corect values, but column X does not use the
correct values. Instead it just uses the rank values. For example. Here is
the input

X Y
20 50
34 65
44 76

Here is what the scatter plot graphs:

X Y
1 50
2 65
3 76

Has anyone had this problem before? Thanks, Jay
 
Jay -

(A) Is it really a scatter chart?

(B) Are the values in the X column really being used as X values? Right
click the chart, choose Source Data from the popup menu, click on the
Series tab. Select the series, and see what's in the X Values box. If
necessary, select the range containing the values.

(C) Are the X values really text, not numeric? If no alignment has been
imposed, numbers are right justified, and text is left justified.
Select and copy a blank cell, select the text cells that are
masquerading as numbers, choose Paste Special from the Edit menu, and
select the Values and Operation - Add options.

- Jon
 
I'm using XL/Win 2000 and have the following problem with scatter plot..
Column Y is plotted with the corect values, but column X does not use the
correct values. Instead it just uses the rank values. For example. Here
is
the input

X Y
20 50
34 65
44 76

Here is what the scatter plot graphs:

X Y
1 50
2 65
3 76

Has anyone had this problem before? Thanks, Jay
Click to expand...

Any chance it's formatted as a line chart rather than a scatter chart?

If you're sure it's a scatter chart, check the source data (select chart,
Chart | Source data | Series tab). Make sure the stuff in the X Values
box is appropriate.
 
Yes, the data is imported correctly. It is a scatter plot, not line plot
(actually line plot distributes the X-values linearly, but DOES use the
actual X-values correctly. In other words, line plot works correctly).

I'm 99% sure the values are numeric, not text, but I will verify.--Jay
 
Back
Top