#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default flow charts

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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 560
Default flow charts

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cash Flow Lindy-Jane Charts and Charting in Excel 1 November 28th 06 02:19 PM
How do I see the line color in my excell flow charts? Duke1 Excel Discussion (Misc queries) 0 October 17th 06 12:59 PM
How do I label flow connectors in and excel flow chart? Hannah Excel Discussion (Misc queries) 1 September 7th 06 07:55 PM
flow charts Kieralee Charts and Charting in Excel 0 March 20th 06 11:11 PM
Cash flow charts Struggling of Essex Excel Discussion (Misc queries) 2 September 28th 05 09:30 PM


All times are GMT +1. The time now is 04:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"