Timeline

[Guest]

Is it possible to create a bar chart type timeline in
Excel. It would have tasks on the verticle axis and the
timeline on the horizantal axis. The result would be a CPM
type bar chart. I've seen it done but don't know if it can
be done on Excel 97. Our IT people say it can't be done
but I've seen it.

 

[dvt]

Is it possible to create a bar chart type timeline in
Excel. It would have tasks on the verticle axis and the
timeline on the horizantal axis. The result would be a CPM
type bar chart. I've seen it done but don't know if it can
be done on Excel 97. Our IT people say it can't be done
but I've seen it.

Sounds like a Gantt chart to me. Try http://come.to/TheGantTool. I've
not used that tool myself, so I can't vouch for its worthiness. If that
one doesn't make you happy, google for Gantt and Excel.

 

[dvt]

Sounds like a Gantt chart to me. Try http://come.to/TheGantTool.

Maybe even better is www.tushar-mehta.com, look for Gantt on the left side
of the page.

 

[Guest]

If Gantt is what you are trying to do, then set the data
using floating bars, an option on the custom types tab of
the chart type dialog box. It plots two series - a start
date and a duration.

 

[Jon Peltier]

It's the job of IT people to say things can't be done. Here's a list of
links showing how to do what can't be done:

http://www.geocities.com/jonpeltier/Excel/Charts/GanttLinks.html

- Jon

 

[Mike Witcombe]

Or www.waa-inc.com/projex

It's the job of IT people to say things can't be done. Here's a list of
links showing how to do what can't be done:

http://www.geocities.com/jonpeltier/Excel/Charts/GanttLinks.html

- Jon