[25464] in Athena Bugs
Re: linux 9.2.25: xess
daemon@ATHENA.MIT.EDU (Joe Foley)
Thu Jan 22 15:26:17 2004
From: Joe Foley <foley@mit.edu>
To: Alex T Prengel <alexp@mit.edu>
In-Reply-To: <200401221913.i0MJDfEg000315@dit.mit.edu>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Message-Id: <1074803121.18753.7.camel@nitrocellulose.mit.edu>
Mime-Version: 1.0
Date: Thu, 22 Jan 2004 15:25:21 -0500
cc: bugs@mit.edu
Errors-To: bugs-bounces@mit.edu
Ahhhh. I feel silly. thanks!
Joe
On Thu, 2004-01-22 at 14:13, Alex T Prengel wrote:
> >>>What's wrong:
> >>>When I graph before the year change, it works fine. however, if the
> >>>period spans over the year change, the graph goes into a very strange
> >>>y-axis as labels instead of numbers.
>
> I think I've figured this out. Cell B30 in the sample spreadsheet you
> pointed me to contains a string, not a number. It just happens to be
> on the row where the date changes to 2004. When I reset it to a number
> everything looked OK (to me anyway). If xess sees even one string in a
> range where everything else is a number, it treats them all as strings
> and it produces some sort of scatter plot instead of the numeric graph
> you were expecting.
>
> Alex
