Two Weeks Till Friday (?) welcome to ambivalence.

Who Knows Excel???

I need Excel help to create a report. While I know what the report should look like, I can't find samples of it on the Internet. Because I am not an Excel guru, I don't even know the correct terms to do a proper search. I would be surprised however if this was never done before. In theory it sounds very doable. In theory.

So in a nutshell, I need a chart to represent how close we are to finishing a task. The main task then all the sub tasks of that main task.

Using a test plan as an example because, well, after all, I'm in QA...

For ease, lets say the following...

I have 2000 test scripts that are estimated to take 5000 hours of testing. So I know that 5000 hours is 100%.

Of that 5000 hours, 500 hours for Feature A, 3500 are for Feature B and 1000 are for Feature C.

So now we know this...
Feature A = 500 hrs = 100%
Feature B = 3500 hrs = 100%
Feature C = 1000 hrs = 100%
All Features = 5000 = 100%

Throughout the project, I know how many hours have been completed for each feature and thus, overall as well. All this data would be imported from another database.

So the dashboard would look something like this...

Total Effort

0% |----------38%|------------------------|100%

Time ||||||||||||||||||||||||||||||||||||| End Date

Feature A

0% |----------------------55%|-------------|100%

Feature B

0% |-----29%|-------------------------------|100%

Feature C

0% |------------------40%|------------------|100%

So I'm trying to figure out how to create a horizontal 'gas' gauge based on imported data. I can't seem to figure out how to do that in Excel.

So if any of you have any thought, I would be most grateful! Even so much as to offer a great bottle of wine? Or scotch? Or Diet Coke?