Forum Discussion
Planner | project templates + timeline (gantt?) view
How do you add a red "today's date" line across your portfolio gantt? I know there is a way to do it - but have no clue where to start! Thank you in advance - I am a bit of an Excel novice.
Hello,
A Gantt chart in Excel is constructed from a horizontal column chart with dates on the X axis.
A red line for the current date can be achieved by putting a XY scatter chart series with two points on the secondary axis. The trick is that the primary and the secondary X (horizontal) axis need to have the same minimum and maximum setting. If Excel does not do that automatically you'll need to adjust the setting manually.
Let me know if that helps.