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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Timeline
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. |
#2
|
|||
|
|||
Timeline
On Tue, 21 Oct 2003 11:43:19 -0700, =
= wrote: 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. -- = Dave dvt at psu dot edu |
#3
|
|||
|
|||
Timeline
On Tue, 21 Oct 2003 16:13:42 -0400, dvt wrote:
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 si= de = of the page. -- = Dave dvt at psu dot edu |
#4
|
|||
|
|||
Timeline
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. -----Original Message----- 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. . |
#5
|
|||
|
|||
Timeline
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/...anttLinks.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ wrote: 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. |
#6
|
|||
|
|||
Timeline
Or www.waa-inc.com/projex
Jon Peltier wrote in message ... 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/...anttLinks.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ wrote: 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. |
Thread Tools | |
Display Modes | |
|
|