Progress Bar Chart
 

Hi everybody
I have a problem for creating a chart. this is a problem of Worldskill
Helsinki 2005 IT-Software application.
Problem:
http://i10.tinypic.com/2zyfqkh.jpg
And data:
Phase Activity Start Date Duration
Planning Phase Planning Meeting 02-Jan 1
Planning Phase Develop Questionnaire 03-Jan 11
Collection Phase Mail Questionnaire 17-Jan 9
Collection Phase Receive Responses 20-Jan 15
Analysis Phase Data Entry 20-Jan 18
Analysis Phase Data Analysis 07-Feb 4
Analysis Phase Write Report 13-Feb 12
Action Phase Distribute to Board 27-Feb 1
Action Phase Board Meeting 01-Mar 1


--
vb_4_net
------------------------------------------------------------------------
vb_4_net's Profile: http://www.officehelp.in/member.php?userid=4660
View this thread: http://www.officehelp.in/showthread.php?t=1226216

Posted from - http://www.officehelp.in

Progress Bar Chart
 

Homework, eh?

The "progress bar chart" is more appropriately called a Gantt chart:

http://pubs.logicalexpressions.com/P...cle.asp?ID=343

The dynamic thing with the dropdown is covered he

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"vb_4_net" wrote in message
...

Hi everybody
I have a problem for creating a chart. this is a problem of Worldskill
Helsinki 2005 IT-Software application.
Problem:
http://i10.tinypic.com/2zyfqkh.jpg
And data:
Phase Activity Start Date Duration
Planning Phase Planning Meeting 02-Jan 1
Planning Phase Develop Questionnaire 03-Jan 11
Collection Phase Mail Questionnaire 17-Jan 9
Collection Phase Receive Responses 20-Jan 15
Analysis Phase Data Entry 20-Jan 18
Analysis Phase Data Analysis 07-Feb 4
Analysis Phase Write Report 13-Feb 12
Action Phase Distribute to Board 27-Feb 1
Action Phase Board Meeting 01-Mar 1


--
vb_4_net
------------------------------------------------------------------------
vb_4_net's Profile: http://www.officehelp.in/member.php?userid=4660
View this thread: http://www.officehelp.in/showthread.php?t=1226216

Posted from - http://www.officehelp.in