Can I plot an equation in Excel instead of plotting data?

raechickx · Sep 21, 2005

Can I plot an equation such as y=13x+8 instead of plotting lists of data?

bj · Sep 21, 2005

No, unfortunately.

Bernard Liengme · Sep 21, 2005

Yes you can with VBA. See
http://www.tushar-mehta.com/excel/software/plot_manager/index.html

Jon Peltier · Sep 21, 2005

Or with worksheet functions:

http://oaltd.co.uk/DLCount/DLCount.asp?file=ChtFrmla.zip

But it's rather complicated, and I often mess it up. It's easier to set
up and debug if you simply calculate the data on the sheet and plot the
results.

Is there any particular reason you don't want to use data on the worksheet?

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

Can I plot an equation in Excel instead of plotting data?

raechickx

bj

Bernard Liengme

Jon Peltier