KPI Data Chart Display
 

Good day all,
Below is a set of data that i am trying to represent as a Chart KPI Display
in excel but i am not sure how to do this as it is a combination of start
milestone/ finish milestones/ and duration period.
Is there a way that this can be done where the activities is shown on the X
axis and the Dates is shown on the Y axis and the data is represented in the
Chart Area?

I am desperate anyone can give me a quick solution? Thanks






Activities
Start Finish

Procurement Plan 27/10/08
Issue OJEU notices with Headline PQQ requirements 31/10/08
Receive Expressions of Interest 01/12/08
01/12/08
Evaluate Expressions of Interest 05/12/08
05/12/08
Tender List Recommendation 19/12/08
Tender List Approval
23/12/08
Prepare ITT 03/11/08
Issue ITT
12/01/09
Tender Period 12/01/09
09/02/09
Tender Returns 06/03/09
Evaluate Tender 06/03/09
27/03/09
Recommendation to award 06/03/09 06/03/09
Internal Approvals 13/03/09
Standstill period 19/01/09
30/01/09
Award 27/03/09

KPI Data Chart Display
 

Here's a couple references on Gantt Charts:

Gantt Charts in Microsoft Excel
http://pubs.logicalexpressions.com/P...cle.asp?ID=343

Advanced Gantt Charts in Microsoft Excel
http://peltiertech.com/Excel/Charts/GanttChart.html

Excel Gantt Chart Template (free)
http://www.vertex42.com/ExcelTemplat...ntt-chart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______



"whatzzup" wrote in message
...
Good day all,
Below is a set of data that i am trying to represent as a Chart KPI
Display
in excel but i am not sure how to do this as it is a combination of start
milestone/ finish milestones/ and duration period.
Is there a way that this can be done where the activities is shown on the
X
axis and the Dates is shown on the Y axis and the data is represented in
the
Chart Area?

I am desperate anyone can give me a quick solution? Thanks






Activities
Start Finish

Procurement Plan 27/10/08
Issue OJEU notices with Headline PQQ requirements 31/10/08
Receive Expressions of Interest 01/12/08
01/12/08
Evaluate Expressions of Interest 05/12/08
05/12/08
Tender List Recommendation 19/12/08
Tender List Approval
23/12/08
Prepare ITT 03/11/08
Issue ITT
12/01/09
Tender Period 12/01/09
09/02/09
Tender Returns
06/03/09
Evaluate Tender 06/03/09
27/03/09
Recommendation to award 06/03/09
06/03/09
Internal Approvals
13/03/09
Standstill period 19/01/09
30/01/09
Award 27/03/09