mcjones@src.dec.com (Paul McJones) (11/13/90)
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