A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

horrifyingly difficult excel chart / gantt question...



 
 
Thread Tools Display Modes
  #1  
Old February 2nd, 2006, 05:49 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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  
Old February 2nd, 2006, 07:08 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.