🚀 go-pugleaf

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