Residential Builder Gantt Chart in Excel

[R. Drapeau]

I am looking to use Excel to develop a gantt chart style form for a
residential builder that would show each step in the building process along
the left, with the ability to pick start and end dates (from a pop up
calendar), and to the right of that have it show the days of the week
(Monday thru Friday) with a colored bar to indicate the start and end dates
selected for the task.

I've seen a vendor product that does this similarly, and the app opens up in
Excel so I believe it is merely a fancy excel spreadsheet. I've done quite
a bit with Excel but nothing to this degree. I'd like to develop this for a
friend of mine because the vendor product is obviously not customizable.

Any thoughts or ideas would be of assistance.

Thank you.

 

[Jim Cone]

R,
I have a small, simple Microsoft workbook chart example from about 7 years ago.
It demonstrates a floating bars Gantt-style timeline chart for a project schedule.
It has some limited notes and explanatory material. (no calendar popup)
I don't believe MS still has it available for download.
Glad to send you a copy if you are interested.
Remove XXX from my email address.

Jim Cone
San Francisco, USA
(e-mail address removed)


"R. Drapeau" <[email protected]>
wrote in message
I am looking to use Excel to develop a gantt chart style form for a
residential builder that would show each step in the building process along
the left, with the ability to pick start and end dates (from a pop up
calendar), and to the right of that have it show the days of the week
(Monday thru Friday) with a colored bar to indicate the start and end dates
selected for the task.

I've seen a vendor product that does this similarly, and the app opens up in
Excel so I believe it is merely a fancy excel spreadsheet. I've done quite
a bit with Excel but nothing to this degree. I'd like to develop this for a
friend of mine because the vendor product is obviously not customizable.

Any thoughts or ideas would be of assistance.

Thank you.

 

[Tom Ogilvy]

Q213447 - XL2000: Visual Basic Module to Create a Gantt Chart
http://support.microsoft.com/?kbid=213447


Q254008 - INFO: Gantt Chart Sample Add-In Available for Download
http://support.microsoft.com/?kbid=254008


Q253338 - INFO: Office Developer Samples and Tools Available for Download
http://support.microsoft.com/?kbid=253338


Q123260 - XL: Visual Basic Module to Create Gantt Chart
http://support.microsoft.com/?kbid=123260


Q213915 - XL2000: How to Create a Gantt Chart Using Hours as the Scale
http://support.microsoft.com/?kbid=213915


Q152820 - XL: How to Create a Gantt Chart Using Hours as the Scale
http://support.microsoft.com/?kbid=152820


Q73281 - Excel: Creating Gantt Charts
http://support.microsoft.com/?kbid=73281


Can't guarantee all of them are still good.

 

[R. Drapeau]

Please do send it if you still have it.

Thank you.

 

[Jim Cone]

R,

Assuming your posted email address is correct, I will send the workbook
as soon as my RCN mail server is running. It has been down now about
14 hours (it is being improved?).

Jim Cone
San Francisco, USA


"R. Drapeau" <[email protected]>
wrote in message Please do send it if you still have it.
Thank you.

"Jim Cone" <[email protected]>
wrote in message
news:[email protected]...