Adding Chart labels dynamically

Here's how I would probably do it:

1) For the payback line, use one of the techniques here for adding a vertical line to a line chart: https://peltiertech.com/Excel/Charts/ChartIndex.html
2) Your profile says you are using Excel 2010, which does not have built in support for "data labels -> values from cells". I like to use Rob Bovey's XY chart labeler add-in (appspro.com) for this task, but you can build your own data labeling tool as well. The basic idea is to link a cell (where you can dynamically build the text) to one of the data labels for this series.
3) For the other label points, add another XY scatter series that positions the label where you want, then link the data labels for that series to cells.

That's how I would do it. Any questions about building and XY scatter + line combination chart? Adding data labels to any of the points/series?

I havent updated my profile in a while. This is Office 365 Pro Plus.

I was able to add the vertical line, but for some reason, cannot get a data label to show up on it.

MSFT's help file for adding data labels: https://support.office.com/en-us/art...2-f467c9f4eb2d I'm not sure I can add anything without knowing exactly what difficulty you are having with the data labels.