graphing a capital investment project

[Hlatigo]

Does anyone know how or what I could do to graph a NPV or IRR or a MIRR?

I have been working on this and thought i could show the point when the project breaks even and then when it becomes profitable but not sure how to go about this. Also..if I have a row of data that may or maynot be blank, how would i be sure the graph takes into account these empty cells but doesnt graph it at zero?

Thanks for your help!!!

 

[RalphA]

As far the secon part of your post, not graphing an empty cell, you could enter #N/A in that cell, and the graph will simply connect the previous point with the next point with a straight line.