Scatter chart without numerical values

[Guest]

For some time now, when I create a scatter chart from tabulated (numerical)
data, the chart does not display the x/y values, but the serquence numbers
instead. This is similar to a bar chart, but should'nt happen with a scatter
chart.
The scatter charts have worked ok in the past. I'm using Excel 2000 in a
company office environment where I have little control over the Excel
installation/set-up.

 

[Bernard Liengme]

Are you really making an XY chart?
If you make a Line chart with two numeric columns AND the first row have
labels, Excel thinks both columns are y-data and uses 1,2,3 for x-category.
Removing label in first column solves this.
I wonder if that is what you have been doing?

 

[Mike Middleton]

Fred -

Be careful that the data are really numbers, not text appearing as numbers.
If even one data point contains text, Excel will use 1,2,3,... instead of
the numerical values.

- Mike
www.mikemiddleton.com

 

[Guest]

Mike,

I think you are right.
I meanwhile found out that the data I used are not treaded as numbers. I get
the figures from a function. When I change the function to =Value(function),
the x-y chart is ok. Therefore I suspect I should have declared the function
as a real. I will try it out.
--
Regards
Fred Geiger

Fred -

Be careful that the data are really numbers, not text appearing as numbers.
If even one data point contains text, Excel will use 1,2,3,... instead of
the numerical values.

- Mike
www.mikemiddleton.com