Multiple trend line scatterplot

[rugger4677]

I have a scatterplot with capital and IRR as the variables, I'd like to overlay this original scatterplot using different assumptions that will affect the IRR. Is that possible to do in excel?

 

[cjcobra]

When I want to see different things on a chart, I use a pull down menu. I have my data set up to look at the pull down and =IF(it equals one things, change the data, etc). then you can pull down and look at different charts on the fly.