Scatter chart without numerical values
 

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.

--
Regards
Fred

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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Fred Geiger" wrote in message
...
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.

--
Regards
Fred

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

"Fred Geiger" wrote in message
...
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.

--
Regards
Fred

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

"Mike Middleton" wrote:

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

"Fred Geiger" wrote in message
...
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.

--
Regards
Fred