Need a template for an aging report

  • Thread starter Born to Write Bugs
  • Start date
B

Born to Write Bugs

I have a spread sheet which I generate weekly for our team. It is a list of
open tasks assigned to team members. Each entry includes the owner of the
task and the date the task was created.

I need to generate a report or chart from this data which shows:

* the number of tasks owned by each team member, and
* the grouping of tasks by age:
* < 1 week
* 1 - 2 weeks
* etc

Is there a template for this sort of chart? If not, where should I look for
information on how to create one?

Thanks in advance for any help.
 
B

Beth Melton

Born to Write Bugs said:
I have a spread sheet which I generate weekly for our team. It is a list
of
open tasks assigned to team members. Each entry includes the owner of the
task and the date the task was created.

I need to generate a report or chart from this data which shows:

* the number of tasks owned by each team member, and
* the grouping of tasks by age:
* < 1 week
* 1 - 2 weeks
* etc

Is there a template for this sort of chart? If not, where should I look
for
information on how to create one?

Thanks in advance for any help.

If you have Project then that's the tool for the scenario you are
describing. Otherwise look into Gantt charts such as this one:
http://office.microsoft.com/en-us/templates/TC300003501033.aspx

Or Google Gantt charts Excel 2007. You should find a wealth of information
on this topic.
--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top