Wrong Interpretation of Excel Value - Scatter Plot Problem

  • Thread starter Thread starter Klaus Kragelund
  • Start date Start date
K

Klaus Kragelund

Hi

At:

www.microdesign.dk/tmp/strange_error.xls

I have an excel file that gives me problems

A scatter plot shows a plot of some Y-values with respect to some
X-values (whoa)

Well, its the scaling or excel number interpretation that gives me
problems.

The x-values goes from 0 to 140, but the graph will only show 0 to ~16

The last x-value is 140 and before that (at cell A18) is a value of
113.4. If I delete that cell the plot suddenly goes from 0 to 140 as it
should. Also if I type in manually 113.4 it is still fine

I have tried changing the formatting of the cell, but I cannot find a
reason for the problem

Does anyone of you experts have an answer?

Thankyou

Klaus
 
If you provide y-values without x-values, then the chart effectively
becomes a "Line" chart, where the x's are equally spaced between 1 and #
observations.

What did you expect Excel to use for the missing x values?

Jerry
 
Jerry said:
If you provide y-values without x-values, then the chart effectively
becomes a "Line" chart, where the x's are equally spaced between 1 and #
observations.

What did you expect Excel to use for the missing x values?
Click to expand...

Well, that wasn't the cause.

I have now updated the Excel sheet at the website and the problem still
exists even when the missing x values are added.

Deleting the A8 cell still gives a correction of the error

Regards

Klaus
 
Klaus -

With an Excel XY (Scatter) chart type, if any cell in the X data range
contains text (or is interpreted as being text), then Excel uses the values
1,2,3,... for the X data. Thus, as Jerry says, the chart effectively becomes
a Line chart type.

Cell A8, a part of the X data range, is formatted as Text.

One way to fix it (by coercing it to be numeric): Enter 0 (zero) into an
unused cell. Edit | Copy. Select cell A8. Edit | Paste Special | Add.

- Mike

www.mikemiddleton.com

+++++++++++++++++++++++
 
Michael R Middleton said:
Klaus -

With an Excel XY (Scatter) chart type, if any cell in the X data range
contains text (or is interpreted as being text), then Excel uses the values
1,2,3,... for the X data. Thus, as Jerry says, the chart effectively becomes
a Line chart type.

Cell A8, a part of the X data range, is formatted as Text.

One way to fix it (by coercing it to be numeric): Enter 0 (zero) into an
unused cell. Edit | Copy. Select cell A8. Edit | Paste Special | Add.

- Mike

www.mikemiddleton.com

+++++++++++++++++++++++
Click to expand...

Thankyou very much for your answer :-)

Regards

Klaus
 
Back
Top