🚀 go-pugleaf

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

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

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