Hi,

Maybe this will help.
http://www.andypope.info/charts/intersection.htm

Cheers
Andy

shy hooi wrote:
i plot two line chart in the same axis. and i need to find value at the
crossing point of the two chart. how could i find the value by using
microsoft excel

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info