Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!mcsun!hp4nl!dutrun!duttnph!ben From: ben@duttnph.tudelft.nl (Ben Verwer) Newsgroups: comp.sys.mac.apps Subject: Re: EXCEL - how to get the proper scale when plotting? Message-ID: Date: 23 Jul 90 07:46:27 GMT References: <1883@ns-mx.uiowa.edu> Sender: tnphnws@dutrun.UUCP Lines: 27 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