+ Reply to Thread
Results 1 to 6 of 6

How to draw chat by entering equation

  1. #1
    Anne
    Guest

    How to draw chat by entering equation

    I am using equation very often these days. How can I draw the chat by
    entering these equations(linear or non-linear)? For example, can I draw the
    linear line in the xy chat by input "y=10+3x", in any environment of office?
    If I can not do so in MS office, anyone know which software can help? Thank
    you so much.

  2. #2
    Tushar Mehta
    Guest

    Re: How to draw chat by entering equation

    (1) Put in the appropriate number of x values (2 for a linear equation)
    in adjacent cells in a column. In the adjacent column, enter the
    equation replacing the 'x' with the address of the cell to the left
    (A2, for example). Plot the x and y values.

    (2) See Stephen Bullen's ChtFrmla.zip at
    http://www.oaltd.co.uk/Excel/SBXLPage.asp#Charting

    (3) See my Plot Manager at http://www.tushar-
    mehta.com/excel/software/plot_manager/index.html

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <10A12486-C416-497B-99DF-1E7D15DDD747@microsoft.com>,
    Anne@discussions.microsoft.com says...
    > I am using equation very often these days. How can I draw the chat by
    > entering these equations(linear or non-linear)? For example, can I draw the
    > linear line in the xy chat by input "y=10+3x", in any environment of office?
    > If I can not do so in MS office, anyone know which software can help? Thank
    > you so much.
    >


  3. #3
    Anne
    Guest

    RE: How to draw chat by entering equation

    Thank you so much for the answer. It's really helpful. Do you mind let me
    know how to draw multiple equations in the same chat? For example, I want to
    draw Y=400+10x + x^2, and equation y=100-10x, and equation y=10 in the same
    chat. Very much appriaciate your help.

    Anne

    "Anne" wrote:

    > I am using equation very often these days. How can I draw the chat by
    > entering these equations(linear or non-linear)? For example, can I draw the
    > linear line in the xy chat by input "y=10+3x", in any environment of office?
    > If I can not do so in MS office, anyone know which software can help? Thank
    > you so much.


  4. #4
    Jon Peltier
    Guest

    Re: How to draw chat by entering equation

    Anne -

    You need one chart series per equation you want to draw. X and Y for the
    first equation in columns A and B, for example, for the second equation
    in columns C and D.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    Anne wrote:

    > Thank you so much for the answer. It's really helpful. Do you mind let me
    > know how to draw multiple equations in the same chat? For example, I want to
    > draw Y=400+10x + x^2, and equation y=100-10x, and equation y=10 in the same
    > chat. Very much appriaciate your help.
    >
    > Anne
    >
    > "Anne" wrote:
    >
    >
    >>I am using equation very often these days. How can I draw the chat by
    >>entering these equations(linear or non-linear)? For example, can I draw the
    >>linear line in the xy chat by input "y=10+3x", in any environment of office?
    >>If I can not do so in MS office, anyone know which software can help? Thank
    >>you so much.


  5. #5
    andrewchen2000@gmail.com
    Guest

    Re: How to draw chat by entering equation

    this excel plot program does not work at all


  6. #6
    Jon Peltier
    Guest

    Re: How to draw chat by entering equation

    Andrew -

    And which plot program might that be?

    The easiest way to plot a function is to enter X values in one column, enter a
    formula in the next column that calculates Y for each X, then select the two columns
    and start the chart wizard.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______

    andrewchen2000@gmail.com wrote:

    > this excel plot program does not work at all
    >



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1