Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!usc!snorkelwacker.mit.edu!bloom-beacon!eru!hagbard!sunic!mcsun!ukc!tcdcs!maths.tcd.ie!mlloyd
From: mlloyd@maths.tcd.ie (Michael Lloyd)
Newsgroups: comp.sys.mac.misc
Subject: Re: Excel charting question
Keywords: Scatterplots
Message-ID: <1990Nov26.210502.6268@maths.tcd.ie>
Date: 26 Nov 90 21:05:02 GMT
References: <47510@eerie.acsu.Buffalo.EDU>
Organization: Dept. of Maths, Trinity College, Dublin, Ireland.
Lines: 36

In article <47510@eerie.acsu.Buffalo.EDU> v132gcnx@ubvmsb.cc.buffalo.edu writes:
>I'm learning how to use Excel 2.2, and I've run across what I consider to be
>a rather major problem.  I would like to use Excel to make numerical graphs.
>From what I see, what would be the x-axis in a graph is the 'category' axis in
>an Excel chart.  The category axis consists of just that; categories.  If I have
>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.  

This is a genuine problem, but not insurmountable.  What you need to do is
make a Scatterplot of the data, which is anything but fun in Excel.  Once
you`ve got it, you can ask (via Gallery...) for a connecting line or what
have you.

The procedure is as follows: (God, how many times have I had to tell people
this?)

Select the data - both columns.
Copy.
New Chart (which will be _blank_ if you copied)
Paste _SPECIAL_, which produces a dialog box.  Make sure "Categories in First
Column" option is ON.
You now have a chart which, if you use Gallery menu, Scatter..., will have
the form you require.

Beaut, huh?  Now what was that about ease of use?

>John Feinberg
>SUNY Buffalo

Hope that sorts it out.

Mike.
Mike Lloyd              !
Dept of Statistics      !    "Cogito, ergo Chico & Zeppo"
Trinity College Dublin  !           - Tonio Krikorian
mlloyd@maths.tcd.ie     !