Graphing a Line Using the Equation

[Guest]

Is there a way to graph a line using the equation of the line?

 

[R.VENKATARAMAN]

try this url
http://www.dicks-blog.com/archives/2005/01/27/professional-excel-development
-sample-chapters/trackback/

see chapter 15 and refer to "charting a function"

============

 

[Tushar Mehta]

See PLOT manager
http://www.tushar-mehta.com/excel/software/plot_manager/index.html

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


--
Regards,

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

 

[Guest]

Here is a very simple application of Stephen's example that Tushar mentioned:

http://www.pdbook.com/index.php/excel/using_defined_names_to_chart_a_function/

 

[Bernard Liengme]

You had some good answers but here is a more simple approach.
To plot 2x^x-4x+6
In A1:A20 enter numbers (1...20 or 1,1.5,2,...)
In B1 enter =2*A1^2-4*A1+6
Copy this down to B20 by double clicking B1's fill handle (little black
square lower right corner)
Select A1:B20, click Chart Wizard and .........
best wishes