software

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: www.excelforum.com/attachment.php?postid=4533 |
-------------------------------------------------------------------

--
1nsomniac
------------------------------------------------------------------------
1nsomniac's Profile: www.excelforum.com/member.php...oamp;userid=32904
View this thread: www.excelforum.com/showthread...hreadid=527238Would need to see data - send file to my private email
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;1nsomniacquot; gt; wrote
in message ...
gt;
gt; Greetings,
gt; I am plotting a simple xy line chart and have run across some weird
gt; behaviour in EXCEL 2002 (SP-2). The reference values are very small
gt; (ie y= 1.9347E-166). The x values range from 400-1000. I have the
gt; values formatted to Numeric with 4 decimal places. Therefore for the
gt; most part the plot should be a flat line running at 0.0000 but for some
gt; reason the plot ranges from 0-1.0000. Moving the cursor over the points
gt; on the chart, the dialog value shows 0.0000E 00 but the chart reads
gt; about 0.98 (see attached).
gt;
gt; Has anyone seen this before? Could it be the values are somehow
gt; wrapping when plotted because they are so small? I'm at a loss.
gt;
gt; Thanks,
gt; 1n
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: EXCEL_prob.jpg |
gt; |Download: www.excelforum.com/attachment.php?postid=4533 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; 1nsomniac
gt; ------------------------------------------------------------------------
gt; 1nsomniac's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32904
gt; View this thread: www.excelforum.com/showthread...hreadid=527238
gt;