Path: utzoo!censor!geac!torsqnt!news-server.csri.toronto.edu!cs.utexas.edu!usc!sdd.hp.com!think.com!mintaka!bloom-beacon!eru!hagbard!sunic!mcsun!ukc!stl!pac
From: pac@stl.stc.co.uk (Paul Cooper)
Newsgroups: comp.sys.mac.misc
Subject: Re: Excel charting question
Message-ID: <3789@stl.stc.co.uk>
Date: 26 Nov 90 18:01:53 GMT
References: <47510@eerie.acsu.Buffalo.EDU> <34567@darwin.ntu.edu.au>
Sender: news@stl.stc.co.uk
Reply-To: "Paul Cooper" <pac@stl.stc.co.uk>
Organization: STC Technology Limited, London Road, Harlow, Essex, UK
Lines: 24

>> 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!

>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).

An even _better_ solution is to use the method buried deep in the Excel
manual.  I don't have the page number to hand but I think it is under
"Scatter Chart".  The basic method is as follows:

1) select data
2) Copy
3) New... Chart
4) Paste special...
5) click on "Categories in first column" check box
6) Scatter... from Gallery menu

This is a common type of chart.  Why make it so awkward, Microsoft?
Regards,
	Paul Cooper (P.A.Cooper@stl.stc.co.uk) - ICL Europe