Results 1 to 6 of 6

Thread: Gant Charts

  1. #1
    wfjdi0r
    Guest

    Gant Charts

    How do I create a Gant Chart using Excel?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Gant Charts

    Try <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/q73/2/81.asp?LN=EN-US&SD=gn&FR=0&qry=Gantt&rnk=7&src=DHCS_MSPSS_gn_SR CH&SPR=XLW>Q73281</A> which gives a method. Whilst at the KB site, do a search on Gantt and you should find more info and downloads.

    Andrew

  3. #3
    wfjdi0r
    Guest

    Re: Gant Charts

    This refers to older versions of Excel. I am using Excel 97. Is there any help there? I did the search at the website but nothing came up.

  4. #4
    Star Lounger
    Join Date
    Dec 2000
    Location
    Tacoma, Washington, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Gant Charts

    Here's another article. Not that much has changed, but this one uses VBA:
    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q123/2/60.asp>How to make a Gannt chart</A>
    <IMG SRC=http://www.wopr.com/w3tuserpics/DougKlippert_sig.jpg>

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Gant Charts

    This might give you some ideas :-
    Q123260 XL: Visual Basic Module to Create Gantt Chart - XL95 & XL97

    Also check out this site <A target="_blank" HREF=http://come.to/TheGantTool>TheGantTool</A>

    Hope something there helps

  6. #6
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Gant Charts

    Of course you should ask yourself, "Is Excel the right tool for this job?" Visio or Project would be the tool of choice to generate a gant chart. On the other hand, if you don't have those tools, then...

    how does it go?...When you have a hammer, all your problems are nails.

    <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

    Mike

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •