Wrong Interpretation of Excel Value - Scatter Plot Problem

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

Klaus Kragelund wrote:

> 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
>
>

Jerry W. Lewis wrote:
> 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?
>

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

> Jerry
>
> Klaus Kragelund wrote:
>
> > 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
> >
> >

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

+++++++++++++++++++++++

"Klaus Kragelund" <[email protected]> wrote in message
news:[email protected]...
>
> Jerry W. Lewis wrote:
>> 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?
>>
>
> 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
>
>> Jerry
>>
>> Klaus Kragelund wrote:
>>
>> > 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
>> >
>> >
>

"Michael R Middleton" <[email protected]> wrote in message news:<[email protected]>...
> 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
>
> +++++++++++++++++++++++

Thankyou very much for your answer :-)

Regards

Klaus

>
> "Klaus Kragelund" <[email protected]> wrote in message
> news:[email protected]...
> >
> > Jerry W. Lewis wrote:
> >> 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?
> >>
> >
> > 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
> >
> >> Jerry
> >>
> >> Klaus Kragelund wrote:
> >>
> >> > 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
> >> >
> >> >
> >