Hi,

See my examples of various ways of adding a datum line to a chart. I'm
pretty sure one of the techniques should work for you.
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

Steve wrote:
I have created a Gantt chart in Excel. I would like to indicate a specific
date - most of the time today's date - by a vertical line showing how many
days have passed and how many yet to go for specific tasks. I have attempted
to create an 'XY graph' on top of the bar/Gantt chart, but the two do not
seem to be compatible.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info