scatter plot problem

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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

seferiad wrote:

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

On Wed, 22 Oct 2003 14:34:08 GMT, seferiad wrote:=


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. He=
re =

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

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.

-- =

Dave
dvt at psu dot edu

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

"Jon Peltier" wrote in message
...
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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

seferiad wrote:

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