Graphs and Excel

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

  1. amilton542

    Thread Starter Active Member

    Nov 13, 2010

    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


    Mar 31, 2012
    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
    I can do it now :cool: