Any Excel experts here?

Simple functions like: 2X + 1Y = 3, 2X - 3Y = 6, etc.

How do you graph something like this?

 

Put your Xs in a column, then your Ys in the next column (using your formula).

Click on the Graph icon (it looks like a 3-D bar graph).

You're off! Choose line graph, no markers, Add Series, put in the range for your Xs and your Ys, give it titles, and tell it where you want the graph (on the worksheet or on a separate chart).

Voila! You have created . . . a line!

(For the equations you gave you have to solve for Y as a function of X first:

Y = -2X + 3

Y = 2/3 X - 2.)

 

[QUOTE]Originally posted by magician
[B]Put your Xs in a column, then your Ys in the next column (using your formula).

Click on the Graph icon (it looks like a 3-D bar graph).

You're off!

 

"Technology, sufficiently developed, is indistinguishable from magic"

Atrhur C. Clark

duffer

 

A Microsoft spreadsheet is magic?

How about a nuclear explosion simulation on a 6,000 processor supercomputer?

- Warren

 

Isn't that what you get when any Microsoft product crashes your computer

 

Oh yes... a Microsoft spreadsheet IS magic. Oh yes.

 

Perhaps I should make a minor change to my business cards:

sleight-of-mouse expert

 

Magic------->Magician........

I'm glad somebody finally made the connection.

 

[QUOTE]Originally posted by magician
[B]Put your Xs in a column, then your Ys in the next column (using your formula).

Click on the Graph icon (it looks like a 3-D bar graph).

You're off!