Hi All,
I am trying to build a project status chart for which I need your help.Here is the sample data:
http://speedy.sh/NCdy3/Project-Status-Chart-data.xlsx
Now let me explain my requirement…
Column A contains the project ID, Col B contains project lead, Col C project end date and Col D talks about how much (%) the project has yet been completed. Before I go further, I want to mention couple of things for your quick reference:
1)Project ID always starts with a letter “S” followed by 4 digit numbers (e.g. S2040)
2)There are only two leads under Project Lead column(Steve and Michael)
3)Sometimes you will see “TBD” is mentioned “Project ID” and “Project End Date” column. It means that either the project has not yet been initiated or project end date has not yet been decided or the both (see row number 14 and 23 for example)
4)There are some rows which are filled with background color (green, yellow, orange etc)and rests of the rows do not have any color filled in it. The rows which do not have any color contain the active projects.
Criteria to screen the data that will go into the chart:
1)All active projects data should go into the chart
2)An active project which do not have any date mentioned in Col C (instead TBD is mentioned), should not be considered in chart data
3)If TBD mentioned in Col A but a date is mentioned in Col C, we should consider that in our chart data.
**Please note that, in Col C date and time are punched together. We need to only fetch date ( e.g. September 26, 2012) in our chart data.
Chart layout:
1)There should be a drop down box containing project leads name(Steve and Michael)
2)If I select Steve, all the project IDs should be populated in rows and to the right hand side a horizontal bar chart which should depict two things…i) Project Status Completion(in %) and how many days are left to complete the project from TODAY’S date.
3)Likewise, when I select Michael, Michael’s related information should be populated as I mentioned above.
Please note that the data rows might expand or shrink every day. So things have to be completely dynamic in nature.
Hope I am able to explain my requirement clearly.
Looking forward to you help.
Kaushik
I am trying to build a project status chart for which I need your help.Here is the sample data:
http://speedy.sh/NCdy3/Project-Status-Chart-data.xlsx
Now let me explain my requirement…
Column A contains the project ID, Col B contains project lead, Col C project end date and Col D talks about how much (%) the project has yet been completed. Before I go further, I want to mention couple of things for your quick reference:
1)Project ID always starts with a letter “S” followed by 4 digit numbers (e.g. S2040)
2)There are only two leads under Project Lead column(Steve and Michael)
3)Sometimes you will see “TBD” is mentioned “Project ID” and “Project End Date” column. It means that either the project has not yet been initiated or project end date has not yet been decided or the both (see row number 14 and 23 for example)
4)There are some rows which are filled with background color (green, yellow, orange etc)and rests of the rows do not have any color filled in it. The rows which do not have any color contain the active projects.
Criteria to screen the data that will go into the chart:
1)All active projects data should go into the chart
2)An active project which do not have any date mentioned in Col C (instead TBD is mentioned), should not be considered in chart data
3)If TBD mentioned in Col A but a date is mentioned in Col C, we should consider that in our chart data.
**Please note that, in Col C date and time are punched together. We need to only fetch date ( e.g. September 26, 2012) in our chart data.
Chart layout:
1)There should be a drop down box containing project leads name(Steve and Michael)
2)If I select Steve, all the project IDs should be populated in rows and to the right hand side a horizontal bar chart which should depict two things…i) Project Status Completion(in %) and how many days are left to complete the project from TODAY’S date.
3)Likewise, when I select Michael, Michael’s related information should be populated as I mentioned above.
Please note that the data rows might expand or shrink every day. So things have to be completely dynamic in nature.
Hope I am able to explain my requirement clearly.
Looking forward to you help.
Kaushik
