• 512-991-7197
  • This email address is being protected from spambots. You need JavaScript enabled to view it.
  • Always Open

Welcome to Microsoft Excel Tips & Tricks

Glossy Gantt chart with a vertical line

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

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:


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

   2.1.   Do one of the following:

  • On the Design tab, in the Data group, choose Select Data:
    2016select data
  • Right-click in the chart area and choose Select Data... in the popup menu:
    2016 select data

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

  • In the Series X values box - the cells with dates ($F$2)
  • In the Series Y values box - constant values (for example, {4}).

   2.3.   Click OK twice.

   2.4.   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:


   4.   Select More Error Bars Options....

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


   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.

Recommend other relevant articles:



© 2019 Austin Laptop [AustinLaptop.Com]. All Rights Reserved.