jlhaferman@l_eld09.icaen.uiowa.edu (Jeffrey Lawrence Haferman) (07/18/90)
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? Jeff Haferman internet: jlhaferman@icaen.uiowa.edu Department of Mechanical Engineering University of Iowa Iowa City IA 52240
doherty@uh.msc.umn.edu (David C. Doherty) (07/18/90)
In article <1883@ns-mx.uiowa.edu> 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? > > >Jeff Haferman internet: jlhaferman@icaen.uiowa.edu >Department of Mechanical Engineering >University of Iowa >Iowa City IA 52240 try the following: 1. select your data points in the spreadsheet 2. select NEW in the file menu 3. open a CHART 4. select PASTE SPECIAL in the EDIT menu 5. "values in columns" should be selected already select also "categories in first column" 6. a bar chart appears (we're almost there...) 7. in the GALLERY menu, select SCATTER plot - the abscissa should now be correctly spaced. LINE plots don't appear to work this way. note: it appears that you must choose PASTE SPECIAL (and have the bar chart appear) BEFORE you choose SCATTER. If you pick SCATTER first, then PASTE SPECIAL is no longer available. you figure it out... hope that this helps. dave doherty minnesota supercomputer center, inc. doherty@uh
ben@duttnph.tudelft.nl (Ben Verwer) (07/23/90)
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. ----------------------------------------------------------------------------- Ben Verwer Lorentzweg 1 tel +31(15)783247 Pattern Recognition Group 2628 CJ Delft fax +31(15)626740 Faculty of Applied Physics The Netherlands Delft University of Technology
aslakson@cs.umn.edu (Brian Aslakson) (07/23/90)
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