Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Graph an Equation in Excel 2007

This is a discussion on Graph an Equation in Excel 2007 within the Excel Questions forums, part of the Question Forums category; I am trying to graph an equation in Excel 2007. There are a couple of examples using named ranges that ...

  1. #1
    New Member
    Join Date
    Feb 2007
    Posts
    4

    Default Graph an Equation in Excel 2007

    I am trying to graph an equation in Excel 2007.

    There are a couple of examples using named ranges that I have tried from the internet that don't seem to work. They both were "programmed" in Excel 4 so it may be related to the difference between these two versions.

    1 simple equation I am trying to graph is y=(4.18T)-(760/t). I would like to be able to change the starting x value and ending x value as well as the number of data points to graph.

    (This is easy to do on a graphing calculator so I would think that Excel could do it)

    Thanks,
    Mike

  2. #2
    VoG
    VoG is offline
    MrExcel MVP
    Moderator
    VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    61,555

    Default Re: Graph an Equation in Excel 2007

    Welcome to MrExcel.

    This should help http://peltiertech.com/Excel/ChartsH...tEquation.html

  3. #3
    New Member
    Join Date
    Feb 2007
    Posts
    4

    Default Re: Graph an Equation in Excel 2007

    Thank you for the welcome. I have been a lurker on this board for a while now.


    I tried both the Stephen Bullen example and the Jan Karel Pieterse example. I get an error message when I open the workbook and also when I try to change the formula to the one I want to use. ("A formula in this worksheet contains one or more invalid references.")

    I also tried to recreate it from scratch using his word document but I get the same error message. I have not found any references that look incorrect according to the instructions.

    Have any of you tried to use either of these in Excel 2007?

    Thanks for your willingness to help,
    Mike
    Last edited by Michael Danielson; Nov 3rd, 2008 at 04:29 PM.

  4. #4
    Board Regular NdNoviceHlp's Avatar
    Join Date
    Nov 2002
    Location
    Manitoba Canada
    Posts
    1,406

    Default Re: Graph an Equation in Excel 2007

    Maybe this link will help? Dave
    http://www.vbaexpress.com/forum/showthread.php?t=22977
    ps. this is XL03 code

  5. #5
    New Member
    Join Date
    Feb 2007
    Posts
    4

    Default Re: Graph an Equation in Excel 2007

    Well so far I have been unsuccessful at getting an equation to graph. Does anyone have any other suggestions or things they have tried that have worked?

    Thanks

  6. #6
    New Member
    Join Date
    Feb 2007
    Posts
    4

    Default Re: Graph an Equation in Excel 2007

    Has anyone tried the above suggestions and had either of them work?

    Thanks

  7. #7
    Board Regular NdNoviceHlp's Avatar
    Join Date
    Nov 2002
    Location
    Manitoba Canada
    Posts
    1,406

    Default Re: Graph an Equation in Excel 2007

    Mike ... I'm really not sure what's up with XL07... it's got some new charting stuff and perhaps your difficulties are version specific. Meanwhile charting equations in XL03 ain't that hard. If you could maybe indicate what, if any, values "t" and "T" mean in your equation... y=(4.18T)-(760/t) then we would have a starting point. Also I will add that when charting an equation the "Y" value always equals some point on the "X" axis and is therefore ALWAYS a function of "X" even though your "X" value is achieved by an equation that excludes "X". Dave

  8. #8
    MrExcel MVP tusharm's Avatar
    Join Date
    May 2002
    Posts
    10,747

    Default Re: Graph an Equation in Excel 2007

    Designed to plot an equation...
    PLOT manager
    http://www.tushar-mehta.com/excel/so...ger/index.html

    You can also adapt to your own function the the three ways I show to plot a normal distribution in
    Drawing a Normal curve
    http://www.tushar-mehta.com/excel/ch...tion/index.htm

    Quote Originally Posted by Michael Danielson View Post
    I am trying to graph an equation in Excel 2007.

    There are a couple of examples using named ranges that I have tried from the internet that don't seem to work. They both were "programmed" in Excel 4 so it may be related to the difference between these two versions.

    1 simple equation I am trying to graph is y=(4.18T)-(760/t). I would like to be able to change the starting x value and ending x value as well as the number of data points to graph.

    (This is easy to do on a graphing calculator so I would think that Excel could do it)

    Thanks,
    Mike

  9. #9
    New Member
    Join Date
    May 2010
    Posts
    1

    Default Re: Graph an Equation in Excel 2007

    Make sure that you don't have any settings that would disable macros. Many times in Excel 2007, a message bar will appear when you open the file that will allow you to enable macros.

  10. #10
    New Member
    Join Date
    Nov 2010
    Posts
    1

    Default Re: Graph an Equation in Excel 2007

    I've tried to draw some kind of equation in excel.
    https://docs.google.com/leaf?id=0B8v...N2RmMzcz&hl=en

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com