Path: utzoo!attcan!uunet!ogicse!decwrl!bacchus.pa.dec.com!jumbo!mcjones
From: mcjones@src.dec.com (Paul McJones)
Newsgroups: comp.sys.mac.apps
Subject: Excel charting bug
Message-ID: <1990Nov12.114315.973@src.dec.com>
Date: 12 Nov 90 19:43:15 GMT
Organization: DEC Systems Research Center
Lines: 31

This problem is present in versions 1.5 and 2.2.

I set up a simple worksheet and chart intended to demonstrate the
trigonometric identity "sin^2(x) + cos^2(x) = 1":

	A			B
1	=ROW()*2*PI()/3		=SIN(A1)^2+COS(A1)^2
2	=ROW()*2*PI()/3		=SIN(A2)^2+COS(A2)^2
3	=ROW()*2*PI()/3		=SIN(A3)^2+COS(A3)^2

As expected, the values in column B are all equal to 1. But copying
column B and pasting it into a new chart gives something that looks
like this:

      1+    _____
       |   /
       |  /
       | /
       |/
      1+----+----+
       1    2	 3

If I plot a second series on the same chart, then Excel correctly plots
this series as a horizontal line with y=1.

Does anyone know if Microsoft has found and fixed this bug?


Paul McJones
mcjones@src.dec.com
decwrl!mcjones