Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!munnari.oz.au!darwin.ntu.edu.au!jennerr
From: jennerr@darwin.ntu.edu.au (Bob Jenner)
Newsgroups: comp.sys.mac.misc
Subject: Re: Excel charting question
Message-ID: <34567@darwin.ntu.edu.au>
Date: 25 Nov 90 13:00:00 GMT
References: <47510@eerie.acsu.Buffalo.EDU>
Organization: Northern Territpory University
Lines: 23

In article <47510@eerie.acsu.Buffalo.EDU> v132gcnx@ubvmsb.cc.buffalo.edu 
(John A Feinberg) writes:
> three sets of points (0,0), (1,1), and (3,3), the three on the x-axis 
will be
> the same distance from the 1 as the 1 is from the zero.  As far as I'm 
concer-
> ned, that makes the chart useless!  What I would like is for Excel to 
'know'
> that the values on both the x and y axes are values, and not categories, 
and
> to graph them properly.  Is there any way to do this?  Otherwise I'll be 
stuck
> with an antiquated graphing program!
This is a pretty common problem with spreadsheets. One solution is to 
enter an equation which interpolates between 2 and 3 ie. include another 
column which takes the average of the values each side - even better, 
paste the table into CricketGraph ( a great, cheap product).
Regards,

Bob Jenner, Northern Territory University
Computing Dep't ITAFE
PO Box 40146, Casuarina NT Australia 0811
Tel 089-466397