# Graphs and Excel

Discussion in 'Math' started by amilton542, Dec 7, 2012.

1. ### amilton542 Thread Starter Active Member

Nov 13, 2010
494
64
Hi,

I want to use Microsoft Excel so as to build graphs in quick succession by means of a "drag-down" procedure - not the tedious process of computin' every value within a range individually.

I can make a few sequences converge doing it this way and that's about it.

It would be with gratitude if someone could show a few examples on how to instantly assemble a few polynomials of the nth degree (a quadratic or somethin') and a couple of trig functions by way of just typin' in the equation and dragging a column down.

Thanks

2. ### WBahn Moderator

Mar 31, 2012
17,736
4,789
You want to look in the Excel Help for how to write formulas and use cell references.

Basically, each value in your calculation that is going to change from one point to the next you want to use a cell reference. Unless you specify an absolute row or column using the dollar sign, when you copy a cell it changes the cell reference so that, for the cell it is copied into, the cell that is referenced has the same relative position to the new cell as in the original. So, for instance, if you have in cell B3 the formula =A3+B2 what this is really saying is that the result in this cell is the sum of the contents of the cell to the left (A3) and the cell above (B2). If you copy this cell down a bunch of rows by dragging the handle in the lower-left corder of the cell (when the cell is selected), the each cell you copy the formula into will result in that cell containing the sum of the cell to its left and the cell above it.

amilton542 likes this.
3. ### amilton542 Thread Starter Active Member

Nov 13, 2010
494
64
I can do it now