Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
cdavidson
 
Posts: n/a
Default Graph to create a Gant Chart

Here's my data:

Task Start Date Duration (in days)
------ ------------ --------------------
A 01-Dec-2005 1
B 02-Dec-2005 3
C 05-Dec-2005 4
D 09-Dec-2005 2

What I'm hoping I can create in excel is a basic graph (in the form of a
basic Gant Chart) that would have the X-axis be the 'Date', the Y-axis
represent the task, and the plotted data be a 'floating' horizontal bar graph
of duration.

For example... Task 'A' would be the highest bar on the Y-axis, starting on
Dec. 1 extending horizontally rightwards for 1 day. Then, the bar below 'A'
would be Task 'B', starting on Dec. 2nd, and extending rightwards for 3 days,
and so on.

Is this possible would excels graphing wizard?

Many thanks for the assistance.


  #2   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Graph to create a Gant Chart

You will need a stacked bar chart for this. The trick is to use the
starting dates as the first bar and make it colorless so that it does
not appear. Depending on your version of Excel and the whims of the
chart wizzard you might not necessarily get what you want, so perform
the following steps.
1. No need to change your data as they are. The layout is perfect.
2. Select task names and start dates and start chart wizard. Choose bar
chart, the second option for sub-type.
3. In the second step, make sure data is in columns, then go to the
series tab. Values should contain the start cells and X-axis labels the
task id cells.
4. Still in the series tab, click ADD series. For values supply the
duration cells and for labels again the task ids.
5. Once finishing with the wizard, format the graph as needed. Double
click the first series and make it colorless and if necessary, double
click the horizontal axis to change the scale.

HTH
Kostis Vezerides

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I create a graph & execute Excel from a non- MS environme CJ Dev Excel Discussion (Misc queries) 2 August 13th 05 01:41 PM
How to create combination stacked area and line chart? BarbAug Charts and Charting in Excel 2 May 19th 05 01:18 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
How do I create a chart.... awright Charts and Charting in Excel 1 May 6th 05 08:35 PM
How do I create a pointer chart, like a speedometer? Ricardo Kozlowski Charts and Charting in Excel 2 March 31st 05 03:23 AM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"