Greetings,
I am plotting a simple xy line chart and have run across some weird
behaviour in EXCEL 2002 (SP-2). The reference values are very small
(ie y= 1.9347E-166). The x values range from 400-1000. I have the
values formatted to Numeric with 4 decimal places. Therefore for the
most part the plot should be a flat line running at 0.0000 but for some
reason the plot ranges from 0-1.0000. Moving the cursor over the points
on the chart, the dialog value shows 0.0000E+00 but the chart reads
about 0.98 (see attached).

Has anyone seen this before? Could it be the values are somehow
wrapping when plotted because they are so small? I'm at a loss.

Thanks,
1n


+-------------------------------------------------------------------+
|Filename: EXCEL_prob.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4533 |
+-------------------------------------------------------------------+

--
1nsomniac
------------------------------------------------------------------------
1nsomniac's Profile: http://www.excelforum.com/member.php...o&userid=32904
View this thread: http://www.excelforum.com/showthread...hreadid=527238

Would need to see data - send file to my private email
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"1nsomniac" wrote
in message ...

Greetings,
I am plotting a simple xy line chart and have run across some weird
behaviour in EXCEL 2002 (SP-2). The reference values are very small
(ie y= 1.9347E-166). The x values range from 400-1000. I have the
values formatted to Numeric with 4 decimal places. Therefore for the
most part the plot should be a flat line running at 0.0000 but for some
reason the plot ranges from 0-1.0000. Moving the cursor over the points
on the chart, the dialog value shows 0.0000E+00 but the chart reads
about 0.98 (see attached).

Has anyone seen this before? Could it be the values are somehow
wrapping when plotted because they are so small? I'm at a loss.

Thanks,
1n


+-------------------------------------------------------------------+
|Filename: EXCEL_prob.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4533 |
+-------------------------------------------------------------------+

--
1nsomniac
------------------------------------------------------------------------
1nsomniac's Profile:
http://www.excelforum.com/member.php...o&userid=32904
View this thread: http://www.excelforum.com/showthread...hreadid=527238