creating a gantt chart automatically

MS EXCEL

    Sponsored Links

    Next

  • 1. THE CUMIPMT() IS NOT PRESENT?
    THE CUMIPMT() IS NOT PRESENT UNDER FINANCIAL FUNCTIONS UNDER EXCEL. WHAT SHOULD I DO?
  • 2. What Is The Name This Chart Type
    Greeting, I would like to build a chart for scheduling workers. What I would like is a chart with time across the top and workers down the left side. There are a number of jobs to be done each day. These jobs range from 1 to 20 hours, most are 2 to 4 hours. The time is broken down by 12 minute intervals. I need to assign each worker as many jobs as they can handle. I saw a chart that was set up with time across the and workers down the side and the jobs are blocked off in the time the job took, in the row of the worker. Each worker is blocking off from 1 to 4 jobs a day. Something like this: 8 9 10 11 12 1 2 3 4 5 Time |----|----|----|----|----|----|----|----|----| Worker A |----|< 3 >|--< 8 >|--< 9 >-| Worker B |< 1 >|--< 5 >|----|----| Worker C |----|----|< 2 >|----| Job 1 is 4 hours in the AM Job 2 is 6 hours starting at 10:00 AM Job 3 is 2 hours any time Job 4 Cancelled Job 5 is 2.5 hours any time Job 6 Cancelled Job 7 Cancelled Job 8 is 2.5 any time Job 9 is 2 hours in the afternoon My first question is: What is this kind of chart called? And my next question is: How do I create one? Anyone have any ideas? Any help would be appreciated/ TIA -Minitman
  • 3. how do i modify a legend
    how do you add subscripts to the legend on an excel graph.i have only managed to superscript the whole name instead of an individual letter.
  • 4. How to make a chart from a list of names?
    If I only hava a long list of names e.g like this; Andy Andy Carol Carol Carol Robert Robert Robert Robert and so on I want to make a chart that shows both the names and how many times the name are occuring in the list. How can I do this with just a long list of names in Excel? Thanks /Chris

creating a gantt chart automatically

Postby Sue W » Sun, 08 Feb 2004 00:23:53 GMT

I have a table that gets imported to Excel that has 
project numbers, begin and end dates. I want to be able 
to create a gantt chart for this automatically on another 
sheet when this data gets imported to the first. It would 
also be nice to be able to have one sheet be by days, 
another by weeks, and another by months. Can anyone tell 
me if there is an existing wizard to do this. Maybe point 
me in the right direction to find information on this?

Thanks, 
Sue

Re: creating a gantt chart automatically

Postby Jon Peltier » Sun, 08 Feb 2004 04:14:00 GMT

Sue -

The best I can do is point you to a list of Gantt chart links I've amassed:

   http://www.**--****.com/ 

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
 http://www.**--****.com/ 
_______






Re: creating a gantt chart automatically

Postby Susan W » Sun, 08 Feb 2004 06:00:22 GMT

Jon - I get an error on that - Invalid link. I went to 
 http://www.**--****.com/ (which by the way is really 
cool) and then clicked on the Gantt Charts from there and 
got the same thing. 
Sue
links I've amassed:

able 
another 
would 
tell 
point 

Re: creating a gantt chart automatically

Postby Debra Dalgleish » Sun, 08 Feb 2004 06:04:00 GMT

This link should work:

    http://www.**--****.com/ 






-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
 http://www.**--****.com/ 


Similar Threads:

1.how do I create a gantt chart in excel

I am looking for the best way to create a gantt chart that will show tasks by 
week with a start date and end date. to be used at home for vegatable 
planting/harvesting.

2.creating gantt charts

I have Excel 2000.  Is there a way, using Excel, that I 
can create gantt charts or do I need additional software?  
What is the best way to create gantt charts for project 
management?

3.Creating a gantt chart using formulas/conditional formatting

Hi, 

I鈥檓 trying to create a Gantt chart in Excel 2007 without using the tables 
tool. This is how my worksheet looks so far:

鈥?One column shows a list of tasks that need to be done, in the next column 
to the right each cell shows the date on which the corresponding task begins.
鈥?In the dates column, the project start date is fixed 鈥?the next date is 
worked out by adding 2 days to the start date, the date after that by adding 
five dates to the date of task 2, and so on. 
鈥?For the next thirty columns, each column in the table has a single day鈥檚 
date as it鈥檚 header.

What I want to do is use a formula or conditional formatting to tell each 
cell to look at the date in the column header, then look at the start date of 
the task in its row and the start date of the task in the row below. If the 
date in the column header falls between those dates, the cell should 
automatically be shaded red.

Can this be done? If so, could someone tell me how or at least point me in 
the right direction. 

Any and all help much appreciated.

Thanks

Karl

4.How to create a link between(Excel) Gantt chart and Excel sour

Unfortunately no answers have been submitted.
-- 
Mag


"MDunigan" wrote:

> Did you get any replies on this?  This looks similar to my question that I 
> just posted.
> 
> Thanks, Mike
> 
> 
> "Mag" wrote:
> 
> > I am trying to create an Excel Spreadsheet as the source for a Gantt Chart 
> > created using Visio.  (Doing this because the Visio Gantt is an anitermediary 
> > step before the Gantt is presented in Powerpoint).
> > 
> > User wants to be able to enter.edit data in the Excel Spreadsheet and have 
> > the updated information appear in the Gantt.  Visio allows importing to 
> > create the Gantt, but no link after the import appears to exist.  Linking to 
> > the Excel Spreadsheet from Visio works, but does not allow reformatting to 
> > Gantt.
> > 
> > Anyone had experience with a similar scenario?  Thanks.
> > -- 
> > Mag

5.How to create a link between(Excel) Gantt chart and Excel source

I am trying to create an Excel Spreadsheet as the source for a Gantt Chart 
created using Visio.  (Doing this because the Visio Gantt is an anitermediary 
step before the Gantt is presented in Powerpoint).

User wants to be able to enter.edit data in the Excel Spreadsheet and have 
the updated information appear in the Gantt.  Visio allows importing to 
create the Gantt, but no link after the import appears to exist.  Linking to 
the Excel Spreadsheet from Visio works, but does not allow reformatting to 
Gantt.

Anyone had experience with a similar scenario?  Thanks.
-- 
Mag

6. Creating A Gantt Chart In Excel

7. Creating a Gantt Chart

8. Grouping in a chart (Gantt Chart)



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 31 guest