chart a time frame

I have a spreadsheet that contains a list of projects
where each project has a start date and an end date.

I need to chart these projects all into one chart showing
the start date and end date for each different project in
a monthly calander type of format with the months going
across the top of the chart from left to right.

I'm having trouble finding a chart that will plot these
dates as point "A" and point "B" with a line in between
for each different project.

What type of chart should I use and how can I get the
results that I'm looking for?

Thank you for your help.
GD

I have a number of links to Gantt chart examples:

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

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

LeninVMS wrote:

I understand you want to plot something like a Gantt chart.

Create a new column called duration = enddate - startdate

Plot Project, StartDate and Duration along the "Floating Bars" custom
type chart. You can change it to 2D if you prefer.

You might face some difficulty in alignment if you are dealing with
days and weeks and months. So I suggest you stick to one unit of
measure.

- Lenin


---
Message posted from http://www.ExcelForum.com/