Help! Gantt time line

**missferoux** · 01-12-2012, 01:31 PM

Hi, new to forum, I pray you can help. I've never needed to ask for help on excel and am REALLY frustrated.
I've researched for hours how to solve this and having no luck at all...I've tried all different sites solutions but they aren't working.

I have a self made gantt excel chart and am trying to add a vertical date line, but everytime I do it, it isn't coming on right - it's either horizontal and not on the right line, or just randomly in the chart.

I have attached the file here, please please someone save me???? gantt for forum.xls

Thanks x

**missferoux** · 01-12-2012, 04:26 PM

I take it no-one can help? I'm on a major deadline with this tonight

**Whizbang** · 01-12-2012, 04:32 PM

If you are interested, here is a great Project Plan/Gantt Chart solution that someone posted a while back.

http://www.excelforum.com/developmen...ion-gantt.html

**tigeravatar** · 01-12-2012, 04:52 PM

missferoux,

am trying to add a vertical date line

I'm not fully sure what this means, but I took it to mean you want vertical major gridlines. Attached is a modified version of your workbook with the Gantt chart having the vertical major gridlines displayed. You right-click on the dates (the axis items) and select Format Major Gridlines, and set line to automatic instead of None. Does that help?

**missferoux** · 01-12-2012, 04:56 PM

Sorry if I wasn't clear. I'm in the middle of that panic you have when you realise you are truly lost!!! I meant a vertical line that automatically indicates todays date. I have entered todays date using the =today( ) formula, but can't seem to be able to find the solution to make a vertical line appear on the chart to indicate where abouts on the project plan we are..does that make more sense?

**tigeravatar** · 01-12-2012, 05:39 PM

missferoux,

I can't think of a way to get what you want using a chart. The problem is that excel doesn't have a gantt, it has to use a stacked bar chart and then make it look like a gantt. However, there is an alternative if you're willing.
While its not a chart, it gets the same idea across using conditional formatting (see attached). Would something like that work for you?

**missferoux** · 01-13-2012, 03:58 AM

No, the line is supposed to move automatically when the date alters. I know it can be done, Jon Peltier and other people have put it on theirs, but it's so complicated that I get lost along the way. Nevermind, but thanks for your help!!

**Andy Pope** · 01-13-2012, 04:44 AM

Add a new series.
Change series to xy-scatter
set series data, XValues references D3, YValues can be left as ={1}
Format secondary value axis to hav a Max =1
Add errorbars to new data series and use 100% minus Y error bar.