Cumulative Line Chart in excel 2007

Hi,

I want to create a Chart in excel that shows cumulative progress of script development from the total number of planned scripts. This chart needs to be a line chart that shows the ‘Total’ number of planned scripts (regardless of status) and then how many scripts out of the total have been developed so far per week. This needs to be created from a software test script preparation and execution tracking data set. Here are the main columns of the data:

1. Test Id: A unique, sequential ID given to a test script.

2. Test Script Name: Simply the script name. Could be redundant since the same script/ table name is shared between multiple modules.

3. Test Script Status: A test script could be in any one of the following statuses. I have the statuses numbered (1..7) to have a consistent clock-wise sequence of a test script’s status when for example extracting a pie-chart for a Module’s overall test scripts statuses (How many are in progress, not started, completed etc.)
• ‘1. Not Started’
• ‘2. In Progress’
• ‘3. Ready for Audit’
• ‘4. In Audit’
• ‘5. In Rework’
• ‘6. Completed’
• ‘7. Removed’

4. Script Dev Start Dt: When a tester starts to work on a test script for developing it, he/ she puts a date in it, updates the status from ‘1. Not Started’ to ‘2. In Progress’. Until a test script is picked up a tester for development, this date is null (empty cell)

5. Script Dev End Dt: When the tester completes writing the script, he/ she update the date in this field and change the status to ‘3. Ready for Audit’ from ‘2.In Progress’.

6. Planned End Dt: This is the target of each test script’s planned end date.

7. Module: A test script could belong to 5 different modules:-
• Mod 1
• Mod 2
• Mod 3
• Mod 4
• Mod 5

Any clues..?

Look at the COUNTIF function and see if that will allow you to get the values you are looking for. Once you have the "counts" prepared, it should be straightforward to generate the chart.