Glossy Gantt chart with a vertical line

Excel 2016 2013 2010 2007
If you need to create a simple Gantt chart, see Creating a Gantt chart or Gantt chart with progress. To add events to your Gantt chart, see Progress Gantt chart with events. This tip will help you to extend those charts by a vertical line that shows the current date.
The Gantt Chart with a vertical line in Excel 365

To add a vertical line in the current date, do the following:

   1.   Add the current date into your worksheet, select this cell, for example, C2:

Data Chart in Excel 365

   2.   Do one of the following to add a new data series with cell C2:

   2.1.   Do one of the following:

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

   2.2.   In the Select Data Source dialog box, click the Add button and in the Edit Series dialog box:

Edit Data Series in Excel 365
  • In the Series X values box - the cells with dates ($C$2)
  • In the Series Y values box - constant values (for example, {2}).

   2.3.   Click OK twice.

   2.4.   Change the secondary axis parameters, and then remove it.

   3.   Select the new data series, then do one of the following:

  • Click on the Chart Elements button, select the Error Bars list, then choose More Options...:
    Chart Elements - Error Bars in Excel 365
  • On the Chart Design tab, in the Chart Layouts group, click the Add Chart Element drop-down list:
    Add Chart Element button in Excel 365

    In the Add Chart Element drop-down list, choose the Error Bars list, then click More Error Bars Options...:

    More Error Bars Options in Excel 365

In the Format Error Bars dialog box, type parameters of the vertical line:

Format Error Bars Options in Excel 365

   4.   Make the new data series invisible. See also How to add a vertical line to the chart.

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

See also this tip in French: Comment créer un diagramme de Gantt brillant avec une ligne verticale.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.