PDA

View Full Version : excel // word question




Heart Break Kid
Apr 12, 2003, 01:37 PM
is there anyway to graph equations in excel or word without actually plugging in the points and adding a tred line?

the equations i want to graph are

1. f(x) = (x+1) / (x^2 -9)
2. f(x) = 4^(x+3)

i want to be able to do them in excel so i can import them into my word doc.

i can figure it out
any help would be very very much appreciated



ebow
Apr 12, 2003, 03:17 PM
I do not believe there is a way to do this exactly as described.

However, you can generate something that will probably suffice:

(Forgive me, I'm testing this on Excel for Windoze -- I believe it's nearly identical for Office v.X)
Make two columns, for x and y.
Fill the 'x' column with a range of values you're interested in, e.g. "=(A5+1)/((A5^2) -9)"
Fill the 'y' column with a formula that reproduces the equation you're using.
Run the Chart Wizard, choose "XY (Scatter)" for chart type, and for chart sub-type choose "Scatter with data points connected by smoothed Lines without markers."
Proceed through the wizard setting up the titles, axes, gridlines, labels, etc. however you want.
If you need to change the x values, you can do that.

Hope this gets you close enough!

Heart Break Kid
Apr 12, 2003, 04:44 PM
for A1 - i have it labled as x and B1 as y

under A1 i filled each box with =(A5+1)/((A5^2) -9) and what do i fill under the B collum?

i dont understand what you mean when you say use the formula that reproduces the equation you're using

can you clarify?

appreciate the help

Heart Break Kid
Apr 12, 2003, 05:03 PM
i got it!!

thank u sooooo much :)