Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!usc!samsung!umich!umeecs!msi-s0.msi.umn.edu!cs.umn.edu!aslakson From: aslakson@cs.umn.edu (Brian Aslakson) Newsgroups: comp.sys.mac.apps Subject: Re: EXCEL - how to get the proper scale when plotting? Message-ID: <1990Jul23.141459.9546@cs.umn.edu> Date: 23 Jul 90 14:14:59 GMT References: <1883@ns-mx.uiowa.edu> Organization: University of Minnesota, Minneapolis, CSci dept. Lines: 53 ben@duttnph.tudelft.nl (Ben Verwer) writes: >jlhaferman@l_eld09.icaen.uiowa.edu (Jeffrey Lawrence Haferman) writes: >>Quick question, hopefully there is a quick answer. I want to plot >>x versus y in Excel. The values of x are not evenly distributed. >>When I use Excel to plot the pairs however, it evenly spaces the >>independent variable (x). eg: >> x | y >> --------- >> 1.0 1.0 >> 2.0 2.0 >> 3.3 3.3 >>Excel will plot the above with the same distance between 3.3 and 2.0 >>as it uses between 1.0 and 2.0 on the abscissa. Solution? >Select the y range, make a new chart, choose any chatter plot, select a point, >change the formula on the top of the screen which was something like: >=SERIES(,,y-range,1) to =SERIES(,x-range,y-range,1), enter, ready. I pulled my hair out over this one! It was a bear to find the answer but here it is (I guess, answer #2): Select your x and y data "Copy" it "New", "Chart" (should be graph, huh. And should be a main menu item, huh.) "Paste Special" (you'll see a little extra now than if you just chose "Paste".) click the box: Catagories in first column "Okay" note: if your data looks like: A B C 1 3.2 7.9 19 2 7 8.2 23 3 -4.3 12 29 4 0 43 0 and you select A1 to B4, and do the paste special/Catagories in first column, the A's (A1-A4) will be the x's, and the B's will be the y's. If you want to use C's as x's and A's as y's, well I don't know. I just moved stuff around to avoid working later than I already had been. I like Excel. LIKE. (Apologies to Pee-Wee) Maybe I should get Wingz? I think it does x, y, and z!! Hint: "Paste Special" is a full menu item. -- Macintosh related: mac-admin@cs.umn.edu All else: aslakson@cs.umn.edu