How to add a vertical line to the chart

This tip about how to add a vertical line in your chart. E.g., this will be useful to show data and highlight a current date.

To add a vertical line to your line or scatter chart, do the following:

    1.    Add the date with current date to you data, for example:

Data in Excel 2016

    2.    Add new date series to your chart, do one of the following:

  • On the Design tab, in the Data group, choose Select Data:
    Data in Excel 2016
  • Right-click in the chart area and choose Select Data... in the popup menu:
    popup in Excel 2016

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 ($D$4)
  • In the Series Y values box - constant value (1):
New Data Series in Excel 2016

    4.    If if it necessary, change data series:

  • Right-click in the new data series and choose Change Series Chart Type... in the popup menu:
    Change Series Chart Type in Excel 2016
  • In the Change Chart Type dialog box, choose the Scatter type:
    Change Series Chart Type in Excel 2016

    5.    On the Design tab, in the Chart Layouts group, click the Add Chart Element icon and choose Error Bars list:

Add Chart Element in Excel 2016

Excel propose several error bars, also you can use More Error Bars Options.... If necessary, you can fine-tune the error bar settings from the Format Error Bars task pane:

Format Error Bars Options in Excel 2016

If you change the date, the chart will be changed too:

Chart with vertical line in Excel 2016

You can then make any other adjustments to get the expected look.