[This followup was posted to microsoft.public.excel.charting with an
email copy to Jenny.
Please use the newsgroup for further discussion.]
If you know the equations of the two lines, just solve them
algebraically. For example, if you have y=x+3 and y=2x, then the
solution is x+3=2x or x=3. The two lines intersect at x=3 and the
corresponding y value, from either equation, will be 6.
If you don't know the equations, and have the data plotted with
straight lines (i.e., the smoothed line option is *not* checked), you
could eyeball the solution with the Interactive Chart Display add-in
that you can download from my web site.
Or, you could use the InterpolatedValue function
(
http://www.google.com/groups?threadm=MPG.1992faa64542b51b98ac1d%
40msnews.microsoft.com) together with Solver to get a solution.
--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
