Luke, thank you for the reply. I agree it would work on multiple charts; however, this chart is for a dashboard where real estate is already at a premium, so that makes panels a sub-optimal option. As to the scaling, the NPV should always be within the hi-lo range of the yearly cash flows...
Thank you so much, Chandoo and community, for a remarkable resource. I have learned an amazing amount and am in peril of knowing "just enough to be dangerous." With that, my question:
I would like to add a few data series with three dimensions of information. I have a combo chart with A)...