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 2013

    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 2013
  • Right-click in the chart area and choose Select Data... in the popup menu:
    popup in Excel 2013

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 2013

    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 2013
  • In the Change Chart Type dialog box, choose the Scatter type:
    Change Series Chart Type in Excel 2013

    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 2013

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 2013

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

Chart with vertical line in Excel 2013

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

Chart with vertical line in Excel 2013

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.