#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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



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
Gantt chart - fill show progress of tasks over task time period??? JohnHamer1977 Excel Discussion (Misc queries) 3 August 29th 06 05:41 AM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 02:49 PM.

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

About Us

"It's about Microsoft Excel"