Glossy Gantt chart with a vertical line
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:
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:
- Right-click in the chart area and choose Select Data... in the popup menu:
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 ($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...:
- On the Chart Design tab, in the Chart Layouts group, click the
Add Chart Element drop-down list:
In the Add Chart Element drop-down list, choose the Error Bars list, then click More Error Bars Options...:
In the Format Error Bars dialog box, type parameters of the vertical line:
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.
