Glossy Gantt chart with a vertical line

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 2013

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 F2:

Data Chart in Excel 2013

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

  • 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:
    Edit Data Series in Excel 2013
    • In the Series X values box - the cells with dates ($F$2)
    • In the Series Y values box - constant values (for example, {4}).
  • Click OK twice.
  • Change the secondary axis parameters, and then remove it.

    3.    Select new date series, under Chart Tools, 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

    4.    Select More Error Bars Options....

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

Format Error Bars in Excel 2013

    5.    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.

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.