Results 1 to 6 of 6
  1. #1
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Creating Gannt Charts (Access97)

    You'll be using the same MS Graph applet to create the chart, whether in Access or Excel, and they're easier to manipulate in Excel. You can still use the Access database as your recordsource for the chart though.
    Charlotte

  2. #2
    Lounger
    Join Date
    Sep 2001
    Location
    NSW, Australia
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating Gannt Charts (Access97)

    I tried to create the Gannt chart without great deal of success in both Access and Excel. I really could not get it to work correctly in either application. Is there are some kind of documentation or better still a sample that shows the way to generate the Gannt chart using either application for one or multiple projects with multiple tasks. Similar to but not necessarily the same as Microsoft Project output (refer to attached picture). Any help would be appreciated. Thanks.

  3. #3
    Lounger
    Join Date
    Sep 2001
    Location
    NSW, Australia
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating Gannt Charts (Access97)

    Hi everyone,

    Does anyone know of a metod to create a Gannt chart in Access 97? We have collected starting and ending dates for various tasks in our project. The data is stored in Access 97 table. I was asked to create some kind of a chart that will display the tasks in easy to read format. It has to work on various users on different machines. Gannt chart format seems the best way to go, however, I had more then my share of problems with ChartWizard/Microsoft Graph 97 when trying to create it. Any help would be great! <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>
    Attached Images Attached Images

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Creating Gannt Charts (Access97)

    You might take a look at Visio. It can produce Gantt charts and you can embed them in Office applications. Otherwise, a search from <A target="_blank" HREF=http://www.google.com>http://www.google.com</A> using the expression

    gantt chart "Microsoft Access"

    returned 510 hits, including <A target="_blank" HREF=http://www.elementkjournals.com/o97/0106/o970161.htm>this one</A>, on turning an Excel spreadsheet into a Gantt chart.
    Charlotte

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Creating Gannt Charts (Access97)

    er, Charlotte, why not Project? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> Is Visio cheaper than Project (that is a reason I could understand).

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Creating Gannt Charts (Access97)

    Actually, I think it may be (except for the enterprise edition, of course), but the reason I didn't suggest it was because <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=71449&page=& view=&sb=&o=&vc=1#Post71449>this post</A> seemed to suggest they were looking for a non-Project alternative, one they could embed in Access or Excel. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

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