At 08:53 AM Thursday 8/25/2005, Alberto Monteiro wrote:
(1) is there any way to mix lines and columns in a graphic?
(2) is there any intelligent way to plot only meaningful values? For
example, if I am plotting densities (A1:A10 is volume, B1:B10 is mass,
C1:C10 is density, but not all of them have decent values: B7:B10 or maybe
B8:B10 are zeroes), I would like to restrict the plot to numbers that are
not zero/zero.
Nope, sorry. I dunno how to do that with Excel, although I vaguely seem to
remember reading about something like (2), but I could be wrong.
However, your question reminded me of something I was doing in FORTRAN
once, where for each star I was studying I needed to enter the mass (in
solar masses), absolute magnitude, and color index (plus other information
as applicable to each individual star) as values on a punched card. As you
probably know, accurate masses are not available for most stars (except for
members of well-studied binaries which can be studied both visually and
visually), so that entry was often left blank, which as you probably also
know, FORTRAN interprets as a zero¹, which of course is not a valid value
for the mass of a star. However, zero is indeed a valid value for both
absolute magnitude and color index (although having both simultaneously
would man that the star was some distance off the main sequence). Anyway,
some interesting results happened if one entered a blank data card, in
which case the program interpreted that all three values were 0.0 . . .
_____
¹This particular FORTRAN compiler did not have ENCODE and DECODE
statements, which would have provided a way of reading the card twice (once
as ASCII literal, once as a floating point value) in order to distinguish
between an entered value of "0.0" and a blank field
-- Ronn! :)
_______________________________________________
http://www.mccmedia.com/mailman/listinfo/brin-l
