Residential Builder Gantt Chart in Excel
 

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.

Residential Builder Gantt Chart in Excel
 

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
XX


"R. Drapeau"
wrote in message
news:CsFZe.12139$y64.10410@trnddc06
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.

Residential Builder Gantt Chart in Excel
 

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.

--
Regards,
Tom Ogilvy



"R. Drapeau" wrote in message
news:CsFZe.12139$y64.10410@trnddc06...
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.

Residential Builder Gantt Chart in Excel
 

Please do send it if you still have it.

Thank you.

"Jim Cone" wrote in message
...

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
XX


"R. Drapeau"
wrote in message
news:CsFZe.12139$y64.10410@trnddc06
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.

Residential Builder Gantt Chart in Excel
 

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"
wrote in message news:%0SZe.3966$il4.2617@trnddc04...
Please do send it if you still have it.
Thank you.

"Jim Cone"
wrote in message
...
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
XX


"R. Drapeau"
wrote in message
news:CsFZe.12139$y64.10410@trnddc06
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.