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 with the current date to the existing Gantt chart, do the following:

Add a new data

   1.   Add the current date to your spreadsheet.

You can use the TODAY () function that returns the current date or just type some data. Don't forget to format the cell to see the correct data.

For example, cell $C$2:

Data Chart in Excel 365

Add the new data series to the chart

   2.   Do one of the following:

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

In the Select Data Source dialog box, click the Add button, then in the Edit Series dialog box:

  • If you add the vertical line to the chart with events (there is at least one scatter data series):
    • In the Series X values box - the cells with the date (in this example, $C$2),
    • In the Series Y values box - the constant value to see the new data point on the horizontal axis (for example, {0}):
    Edit Data Series in Excel 365
  • If you add the vertical line to the simple Gantt chart or Progress Gantt chart (there are no scatter data series on the chart):
    Edit Data Series 2 in Excel 365

After clicking the OK button twice, Excel adds the new data to the chart:

New data series in the chart Excel 365

Note: If you added a new data series to the Gantt chart without events, you need two additional steps:

   2.1.   Change the data series chart type:

Right-click on any data series and choose Change Series Chart Type... in the popup menu:

Change Series Chart Type in Excel 365

In the Change Chart Type dialog box, for the new data series, choose the Scatter type (the Secondary Axis checkbox is selected automatically):

Change Chart Type in Excel 365

   2.2.   Correct the data series:

Open the Select Data Source dialog box, select the added data series and click the Edit button.

In the Edit Series dialog box, in the Series X values box, select the cell with the date (in this example, $C$2):

Edit Data Series in Excel 365

After clicking the OK button twice, Excel adds the new data to the chart:

New data series in the chart Excel 365

Add the vertical line

   3.   Select the new data, 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 dropdown list:
    Add Chart Element button in Excel 365

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

    More Error Bars Options in Excel 365

See more about other options in Adding Error bars.

 - Customize the Y Error Bars: on the Format Error Bars pane, type parameters of the vertical line:

Format Error Bars Options in Excel 365

 - Remove the X Error Bars by selecting this chart element and clicking the Delete key. See how to select different chart elements quickly.

Correct and hide the secondary vertical axis

   4.   Do the following:

   4.1.   Right-click on the secondary vertical axis and select Format Axis... in the popup menu (or double-click the axis):

Format Axis popup in Excel 365

   4.2.   On the Format Axis pane, on the Axis Options tab:

  • In the Axis Options section, correct the value in the Maximum field:
    Format Axis pane in Excel 365
  • In the Labels section, from the Label Position list, choose None:
Hide Axis labels in Excel 365

   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.

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

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.