Re: GANTT CHART - sort of?

[NPARRAY <NPARRAY@PLIPDECO.COM>]

I haven't tried this but a quick search in google will give you some
examples such as this

http://www.mrexcel.com/tip058.shtml

This should set you on the right path.

HTH

Navin

> -----Original Message-----
> From: Barbara March [mailto:barbara.march@SURVEYRISK.CO.UK]
> Sent: Saturday, 26 July 2003 05:24
> To: EXCEL-G@PEACH.EASE.LSOFT.COM
> Subject: GANTT CHART - sort of?
>
>
>  HYPERLINK
> "http://skins.hotbar.com/skins/mailskins/st/042102/042102email
> _2.gif"Gre
> etings everyone.
>
> Can someone help me to put this together, please?
>
> I have a long list of names which make up a workforce, a list of many
> contracts and the dates (to and from) when individuals from the
> workforce will work on these contracts. Some individuals will stay on
> one contract for the duration, others will work at various
> times on some
> of the contracts.
>
> I am trying to create a spreadsheet which will show the names of the
> workforce on the left and, on the right, a Gantt chart effect spanning
> five years where the contracts are colour coded and  a visual
> representation is created of the deployment of the workforce.
>
> As more names will be added to the list, it would be great if the code
> could be dynamic, and a button to run it?
>
> I believe that Conditional Formatting is no good as there are
> not enough
> conditions and would not show one person working on several contracts.
> So I am assuming it would have to be a VBA code using IF ELSE ???? My
> knowledge in this area is very limited so I'm hoping that one of the
> experts will have a few minutes to spare to put something together for
> me.
>
> Many thanks.
>
> Regards
>
> Barbara UK  (@_@)/
>
>    _____
>
> HYPERLINK
> "http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotb
ar%5feleme
nt%3bst%3b&SG=&RAND=19684"Upgrade Your Email - Click here!

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.456 / Virus Database: 256 - Release Date: 18/02/2003


--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G