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.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more