How do I add an indicator line to a Gantt chart in excel?

#1 09-09-2005, 12:05 PM

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.

#2 09-09-2005, 06:05 PM

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)