Gantt Chart Bar

I'm trying to develop a line or bar that extends through cells representing a range between two dates. For example. Date 1 is in A1 and Date 2 is in B2. There are dates that are 7 days apart in cells E8 through E21. I need a line or a bar that will represent the dates. Thanks very much.

Thanks for the info. I really need to know the formulas for doing it myself. This spreadsheet didn't contain any obtainable formulas. But thanks, I may use this down the road.

This post might help:

http://www.excelforum.com/excel-prog...html?p=3051369

Also see this fileDashboard (dec 19, v4 Shared).xlsm

Hope this helps.

You can also download for free here: http://best-excel-tutorial.com/56-ch...16-gantt-chart
There is link to Google Docs at the very end of the tutorial