A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

creating a gantt chart automatically



 
 
Thread Tools Display Modes
  #1  
Old February 6th, 2004, 04:23 PM
Sue W
external usenet poster
 
Posts: n/a
Default creating a gantt chart automatically

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
  #2  
Old February 6th, 2004, 08:14 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default creating a gantt chart automatically

Sue -

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

http://peltiertech.com/Excel/GanttLinks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Sue W wrote:

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


  #3  
Old February 6th, 2004, 10:00 PM
Susan W
external usenet poster
 
Posts: n/a
Default creating a gantt chart automatically

Jon - I get an error on that - Invalid link. I went to
http://PeltierTech.com/Excel/ (which by the way is really
cool) and then clicked on the Gantt Charts from there and
got the same thing.
Sue
-----Original Message-----
Sue -

The best I can do is point you to a list of Gantt chart

links I've amassed:

http://peltiertech.com/Excel/GanttLinks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Sue W wrote:

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


.

  #4  
Old February 6th, 2004, 10:04 PM
Debra Dalgleish
external usenet poster
 
Posts: n/a
Default creating a gantt chart automatically

This link should work:

http://www.peltiertech.com/Excel/Charts/GanttLinks.html

Susan W wrote:
Jon - I get an error on that - Invalid link. I went to
http://PeltierTech.com/Excel/ (which by the way is really
cool) and then clicked on the Gantt Charts from there and
got the same thing.
Sue

-----Original Message-----
Sue -

The best I can do is point you to a list of Gantt chart


links I've amassed:

http://peltiertech.com/Excel/GanttLinks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Sue W wrote:


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


.




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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.