Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fred Geiger
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Chart -- How to chart 65536 values in 1 series? kilmaley11 About this forum 0 June 8th 05 11:19 AM
Chart Axis Scale Auto Values Moses Bunting Charts and Charting in Excel 1 June 7th 05 11:03 PM
Scatter Chart Axis as text C# Pablo Villalobos via OfficeKB.com Charts and Charting in Excel 1 March 18th 05 10:10 PM
On a scatter chart show two point have same value Maz Page Charts and Charting in Excel 1 December 16th 04 01:00 PM


All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"