Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display data values in columns on bar chart | Excel Discussion (Misc queries) | |||
Chart help - cannot display all data | Excel Discussion (Misc queries) | |||
Graph - Display Y axis data at top of chart(?) | Excel Discussion (Misc queries) | |||
Display a chart only if there is data | Excel Discussion (Misc queries) | |||
Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) |