How do I chart date ranges with varying start and finish dates?

[Guest]

I want to create a chart that on one axis will show date ranges that have
varying start and finish dates. The other axis is a list of project names.
Example: Project #1, starts 5/1/05, ends 10/1/05; Project #2 starts 3/5/05,
ends 2/2/06, etc. I want a bar chart that I can sort. Any help is very
appreciated. : )

 

[Guest]

It sounds like you need to create a Gantt chart. Here are some resources
that might help:

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

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

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343

 

[Guest]

Wow. Thank you, John. I think I am in love. PERFECT help info, just what I
needed.

 

[Jon Peltier]

Hey, he didn't do any of the work!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

: ) Then you get kisses, LOTS of 'em!
xxxxxxxxxxxxxxxx...

Nancy
projectplanner