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