Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!thunder.mcrcim.mcgill.edu!snorkelwacker.mit.edu!apple!agate!shelby!msi.umn.edu!cs.umn.edu!aslakson
From: aslakson@cs.umn.edu (Brian Aslakson)
Newsgroups: comp.sys.mac.apps
Subject: Re: MS Excel
Keywords: charts
Message-ID: <1991Jan31.203753.10111@cs.umn.edu>
Date: 31 Jan 91 20:37:53 GMT
References: <6454@ecs.soton.ac.uk> <36577@netnews.upenn.edu>
Organization: University of Minnesota, Minneapolis, CSci dept.
Lines: 37

myers@eniac.seas.upenn.edu (Franklin Myers) writes:
>Does anyone know how to plot a series of numbers that are not of equal 
>intervals and still retain proper distances on the plot???

Who is doing the FAQ these days?  

Here is something I saved:

In article <1990Nov26.170159.24659@cs.umn.edu>, aslakson@cs.umn.edu (Brian Aslakson) writes:
> Someone wants to do x,y graphs in Excel.  Ugh.  You have to have the x and
> y data next to each other, x to the left, and select both sets of numbers
> and "Copy".  Start a new graph, then "Paste Special", click the box that says
> "Catagories in First Column" and click "Okay".  I just tried it and it worked
> just like that.
> I used "Scatter" for my type, I have a feeling "Pie" won't work as well.
>
> For x,y graphs, Excel sucks.  For x,y,z graphs, go fish.
>
Actually, the columns don't have to be consecutive--I used to think so as
well, but somebody on the net corrected me.  You select the x column first,
and then select the other column while holding down either the option key
or the command key (I don't have Excel handy here, or I would tell you for
sure--I am almost positive it is the option key).

If you are really dissatisfied with Excel for plotting, I recommend Delta-
Graph.  It is much more powerful than CricketGraph (and only a little more
difficult to use), and it does excellent 3d graphs.  It also imports Excel
files directly.

Jay Boisseau
jay@emx.utexas.edu

-- 
Brian Aslakson

aslakson@cs.umn.edu
mac-admin@cs.umn.edu  <-= Macintosh related