Drop line automatically at the crossing of 2 line graphs

[manish_1112]

Hi All,

It could just be a simple trick but I'm having hard time trying to figure out where this is in excel. I have a 2 line bar graph which changes everyday based on the new data. What I want is to drop a line/arrow (like shown here http://prntscr.com/7m8meu) wherever the 2 lines cross each other.

Thanks,
Manish

 

[NARAYANK991]

Hi Manish ,

See if this helps :

http://www.listendata.com/2012/10/excel-intersection-between-curve-and.html

Narayan

 

[p45cal]

Attach or link to a workbook with your data so that we can play with it; it's better than us guessing what you have (eg. are the points in both graphs equal in number, equally spaced without missing data etc.etc.)