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
|
|||
|
|||
horrifyingly difficult excel chart / gantt question...
Hi,
Sounds complicated, but will save a heap of time for me... I've got some data (actually exported from MS Project) in the following format: task name | duration | start date | finish date | level --------------------------------------------------------------------------------------------------- task 1 | x | 1/1/6 | 30/1/6 | 1 task 2 | y | 5/1/6 | 20/1/6 | 2 milestone 1 | z | 25/1/6 | 15/1/6 | 3 and I want to roll these up into a gantt style chart (for one reason or another, this has to be done in excel rather than project...)... I would like the chart to look something like this: | |##################### = task 1 | #######()###### = task 2 with it's embedded milestone | | | | | | | | -------------------------------------------------- ie, task one (at level one) has a number of lower level tasks (at level 2) beneath it... each of these have one or more milestones (at level three) in them... I'm nowhere near expert at excel charting and this is proving to be a real challenge - I've got over 200 level one tasks so *really* don't want to have to do it all by hand! Many thanks, Chris |
#2
|
|||
|
|||
horrifyingly difficult excel chart / gantt question...
Here is an article showing rudimentary Gantt charting in Excel:
http://pubs.logicalexpressions.com/P...cle.asp?ID=343 and this adds a few advanced features: http://peltiertech.com/Excel/Charts/GanttChart.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote in message oups.com... Hi, Sounds complicated, but will save a heap of time for me... I've got some data (actually exported from MS Project) in the following format: task name | duration | start date | finish date | level --------------------------------------------------------------------------------------------------- task 1 | x | 1/1/6 | 30/1/6 | 1 task 2 | y | 5/1/6 | 20/1/6 | 2 milestone 1 | z | 25/1/6 | 15/1/6 | 3 and I want to roll these up into a gantt style chart (for one reason or another, this has to be done in excel rather than project...)... I would like the chart to look something like this: | |##################### = task 1 | #######()###### = task 2 with it's embedded milestone | | | | | | | | -------------------------------------------------- ie, task one (at level one) has a number of lower level tasks (at level 2) beneath it... each of these have one or more milestones (at level three) in them... I'm nowhere near expert at excel charting and this is proving to be a real challenge - I've got over 200 level one tasks so *really* don't want to have to do it all by hand! Many thanks, Chris |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can you make a gantt chart in excel and import it to Project | Bruce | General Discussion | 2 | November 19th, 2005 04:59 AM |
Survey Results | SAm | Running & Setting Up Queries | 10 | May 17th, 2005 08:32 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
resizing chart title box Excel 97 | Andy Pope | Charts and Charting | 1 | February 28th, 2004 04:26 AM |
Custom color question + smooth chart curves question | Gern Blanston | Charts and Charting | 2 | November 14th, 2003 03:42 AM |