Thread: 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

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/
_______


<chris_culley@yahoo.com> wrote in message
news:1138898970.457544.130870@g49g2000cwa.googlegroups.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
>