chart a time frame

  • Thread starter Thread starter GD
  • Start date Start date
G

GD

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 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" custo
type chart. You can change it to 2D if you prefer.

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

- Leni
 
Back
Top