Plotting an X Intercept point on a line graph

[Kaku2000]

Hello,

I need help in creating an x intercept point that moves/changes when the graph changes. I have managed to just plot the x intercept but can't get it to move with the graph as it changes.

I have attached pictures to help show what I mean.

Thanks,

 

[DRSteele]

One way is to create another Series that is on the same Axis. Make a formula so that it contains 0 for every Y and NA() for every point except the one point for the Discount Rate. Then, format the Series with Data Labels.

 

[Kaku2000]

I'm not entirely sure how to do that. Can you maybe provide an example formula? Also, do I add the formula in the following:

 

[DRSteele]

It seems so hard to explain in prose how to create charts. I made a file and put it in OneDrive so that you can download it. Look through the settings for the Chart. Notice it has only one data point because the formula in the dataset puts the IRR near the discount rate that matches closest to it. The data label is linked to the dataset column title.

Any time you wish to have a chart that has a sliding data point like yours, you need to create a new series, but it can't have blanks, "" or 0 because the chart engine will try to plot them and the line will be visible across the entire axis; the way around it is to intentionally create NA(), which the engine will not plot. Watch this video by Mynda to see a demonstration.

The IRR is the discount rate that sets NPV to zero.

 

[Kaku2000]

Thank you so much! I believe I have got it. I'll test my model and see if the graph works with different scenarios.