Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!src.honeywell.com!msi.umn.edu!cs.umn.edu!aslakson From: aslakson@cs.umn.edu (Brian Aslakson) Newsgroups: comp.sys.mac.misc Subject: Re: Excel charting question Message-ID: <1990Nov26.170159.24659@cs.umn.edu> Date: 26 Nov 90 17:01:59 GMT References: <47510@eerie.acsu.Buffalo.EDU> Organization: University of Minnesota, Minneapolis, CSci dept. Lines: 14 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. -- Brian Aslakson aslakson@cs.umn.edu mac-admin@cs.umn.edu <-= Macintosh related