Path: utzoo!attcan!uunet!tut.cis.ohio-state.edu!uc!uh!doherty
From: doherty@uh.msc.umn.edu (David C. Doherty)
Newsgroups: comp.sys.mac.apps
Subject: Re: EXCEL - how to get the proper scale when plotting?
Message-ID: <2161@uc.msc.umn.edu>
Date: 17 Jul 90 18:06:59 GMT
References: <1883@ns-mx.uiowa.edu>
Sender: news@uc.msc.umn.edu
Reply-To: doherty@uh.UUCP (David C. Doherty)
Organization: Minnesota Supercomputer Center, Minneapolis, MN
Lines: 44

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