Hi,
Have a look at Stephen Bullen's ChtFrmla example.
http://www.oaltd.co.uk/Excel/SBXLPage.asp#Charting
To calculate intersection you will probably need to create all the points in
cells in order to use formula, which sort of negates the need for the non
cell based approach
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"GraphLady" wrote in message
...
Can Excel do linear programming problems? I'm wondering if Excel can graph
from an equation rather than data points and can it identify points of
intersection?