Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!helps!bigtex!pmafire!geoff From: geoff@pmafire.inel.gov (Geoff Allen) Newsgroups: comp.sys.mac.misc Subject: Re: Excel charting question Keywords: Scatterplots Message-ID: <1990Nov30.191204.8817@pmafire.inel.gov> Date: 30 Nov 90 19:12:04 GMT References: <47510@eerie.acsu.Buffalo.EDU> <1990Nov26.210502.6268@maths.tcd.ie> Organization: WINCO Computer Engineering, INEL, Idaho Lines: 24 mlloyd@maths.tcd.ie (Michael Lloyd) writes: |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? And to think that Microsoft has taken out big two-page ads in all the magazines asking people to tell them what they're doing wrong with Excel.... :^) -- Geoff Allen \ Computers are useless. uunet!pmafire!geoff \ They can only give you answers. geoff@pmafire.inel.gov \ -- Pablo Picasso