HELP- Weird Charting Bug
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 |
HELP- Weird Charting Bug
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 |
All times are GMT +1. The time now is 12:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com