Solved

Creating an auto updating Gantt chart from an excel 2010 database

Posted on 2014-04-21
3
984 Views
Last Modified: 2014-12-01
Hi Guys

I need your help in creating a Gantt chart from an existing excel data base.
What is the best most easy way to do so and how? Is it possible to do so in excel using Pivot?
Or maybe using Visio?

Thanks
0
Comment
Question by:marmoor99
  • 2
3 Comments
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst
Ingeborg Hawighorst earned 100 total points
ID: 40013858
Hello,

a Gantt chart can be created in Excel by using a horizontal stacked bar chart with a time scale on the horizontal axis.  The duration is typically expressed in days. The task bars are stacked on helper bars that are formatted to be invisible, with no fill and no line.

The screenshot shows a typical data layout with Task name, start date and duration in days. Plot the start date and the duration as stacked horizontal bars. Format the horizontal axis to begin at a specific date. Format the start date bar to have no fill and reverse the plot order, so the earliest task is at the top.

gantt
Chandoo has a great tutorial for project management with Excel over on his site: http://chandoo.org/wp/2009/06/16/gantt-charts-project-management/

Take a look at the tutorial. If you get stuck, please post a data sample so we can work with your data.

cheers, teylyn
0
 
LVL 30

Assisted Solution

by:Scott Helmers
Scott Helmers earned 200 total points
ID: 40014723
Visio includes an import wizard that will create a Gantt Chart automatically from your data. (The instructions below are for Visio 2010/2013 but will be similar in Visio 2007 or earlier.)

Select File>New>Schedule>Gantt Chart to open a new Gantt Chart diagram. Click Cancel to close the dialog that appears when the diagram opens. Then on the Gantt Chart tab, in the Manage group, select Import Data. Step through the wizard to select your file. Visio will attempt to map the column names in your Excel file to Gantt Chart field names; any that it misses you can map yourself.

One tip: you can make the import process smoother by setting the column names in your Excel data to match the Visio field names, thereby eliminating the need to map column names to fields. If you're not sure what column names to use, simply start with an existing Visio Gantt Chart (even one with dummy data) and select Gantt Chart>Manage>Export Data, select Excel as the output type, and then open the resulting Excel file.
0
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 200 total points
ID: 40014769
I wrote an article about automatically creating Gantt Charts with Visio a few years ago -- I'd forgotten about it when I posted my response above, but here is the link to the article.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL 11 80
Need way to extend view in MS Access 47 73
Data quality checks 2 51
C# Application Local DB Connection String 23 113
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Viewers will learn how to customize the ribbon and quick access toolbar in Excel 2013.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now