How to add a vertical line to the chart
To add a vertical line to your line or scatter chart, do the following:
1. Add the date with current date to your data, for example:
2. Add a new data series to your chart, do one of the following:
- On the Design tab, in the Data group, choose Select Data:
- Right-click in the chart area and choose Select Data... in the popup menu:
In the Select Data Source dialog box, click the Add button and in the Edit Series dialog box, type:
- In the Series X values box - the cell with current date ($C$1)
- In the Series Y values box - constant value (100):
3. Select new date series, under Chart Tools, on the Layout tab, in the Analysis group, choose the Error Bars and then select More Error Bars Options...:
In the Format Error Bars dialog box, type parameters of the vertical line:
You can then make any other adjustments to get the expected look.