Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
When I was in construction, we had a paper flow chart that had horizonal
lines for WHO and for HOW LONG. First day of construction (April 1st) was for the earth movers, (7 days) Just underneath that was the survayors. (Started on the 5th day of earth movers and lasted 4 days) Then came the trenchers to put in the underground piping (April 8th, for 3 days), Electricians (April 8th 4 days) If you get the gist of the chart, is there one out there that will simply show this? BTW, the bars were colored and you could see at a glance as to what was supposed to be happening on any given day. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
On Fri, 13 Apr 2007, in microsoft.public.excel.charting,
FrankB said: When I was in construction, we had a paper flow chart that had horizonal lines for WHO and for HOW LONG. First day of construction (April 1st) was for the earth movers, (7 days) Just underneath that was the survayors. (Started on the 5th day of earth movers and lasted 4 days) Then came the trenchers to put in the underground piping (April 8th, for 3 days), Electricians (April 8th 4 days) If you get the gist of the chart, is there one out there that will simply show this? Google for "Gantt chart". This sort of graph is named after Henry Gantt, a project engineer in the first half of the twentieth century. Project management software is designed to produce this sort of graph, but Excel can do it too with a little ingenuity. The key is to choose the horizontal "Stacked Bar Chart" type, include bars for the length of time before the start as well as the task duration, and then format the "time to start" bar to be invisible. This leaves the duration bar appearing to float in the middle of the graphical space. You can label the vertical axis with project members or task types, and the horizontal axis with time or date. Googling for "Excel Gantt chart" should produce a large number of examples and tutorials. BTW, the bars were colored and you could see at a glance as to what was supposed to be happening on any given day. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cash Flow | Charts and Charting in Excel | |||
How do I see the line color in my excell flow charts? | Excel Discussion (Misc queries) | |||
How do I label flow connectors in and excel flow chart? | Excel Discussion (Misc queries) | |||
flow charts | Charts and Charting in Excel | |||
Cash flow charts | Excel Discussion (Misc queries) |