How to draw chat by entering equation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
(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
 
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 -

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/
_______
 
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/
_______
 
Back
Top