excel // word question

Discussion in 'Mac Apps and Mac App Store' started by Heart Break Kid, Apr 12, 2003.

  1. Heart Break Kid macrumors 6502a

    Joined:
    Feb 13, 2003
    Location:
    Toronto
    #1
    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
     
  2. ebow macrumors 6502a

    ebow

    Joined:
    Apr 30, 2001
    Location:
    Trapped in a world before later on
    #2
    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!
     
  3. Heart Break Kid thread starter macrumors 6502a

    Joined:
    Feb 13, 2003
    Location:
    Toronto
    #3
    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
     
  4. Heart Break Kid thread starter macrumors 6502a

    Joined:
    Feb 13, 2003
    Location:
    Toronto

Share This Page