Ms Excel

I'm a high-level no0b who never used excel before. Now, my phys. teacher told us to graph the data we are supposed to enter in the cells. My problemo is that the MTFKing chart displays two lines, one for TIME and another for DISPLACEMENT. WHERE it is supposed to plot a DISPLACEMENT Vs. TIME graph, which contains only one line for VELOCITY (Displacement/Time).

I can't figure out how to do the formula to divide Displacement by Time. The data are in two colums (A & B),w here A is Time and B is displacement. There are 13 rows of data for each column, how do I make a formula to devide every row in column B(Displacement) by every row in column A(Time). I also wanna be able to make a graph for the data was entered.




Edit: NVM PROBLEM FIXED. Just 1 o' these stupid mittakes I've made (I always do). :huh: :blink: :P B)

:lol: You confused the hell out of me there. :P

Burritto :blink: :blink: :huh: :huh:

Quote:

---

Originally posted by haxor41789@3 March 2004 - 10:55
:lol: You confused the hell out of me there. :P

---

'cause I wuz confused too, so how do I explain something that I dun understand :P

for the graph highlight the 2 columns and choose a XY-Scatter Graph (connected with smooth lines).

to do the formula do "=B1/A1" (no quotation marks) where a1 is a result for displacement and b1 is a result for time. to do the formula for every cell either copy and pase it or drag the little black box down in the bottom-right of the cell the formula is in.

Thnx alot. I already figured out how to do the graph, but I didn't know how to do the formula for all of them untill you told me, thnx again :)