Looking for Manpower Templete Help

J

John Smith

I am interested in creating a stacked line chart that will display my
manpower overtime. I would like it to look just like a stock price
chart. X will be the dates per day and Y will be the number of
personnel available. Information that will be available will be Name
for the legend and the inclusive dates of their duty. This will need to
run the fiscal year from 01 Oct 04 to 30 Sep 05.
Below an example of the data that need to be in the spread sheet. Thanks.

Name Start Date End Date
Person 1 12/1/2004 5/31/2005
2 10/1/2004 12/31/2004
3 12/1/2004 9/30/2005
3 11/20/2004 9/30/2005
4 11/29/2004 12/28/2004
5 11/29/2004 1/12/2005
6 12/1/2005 9/30/2005
7 11/13/2004 5/13/2005
8 12/4/2004 3/5/2005
9 11/29/2004 2/26/2005
10 11/21/2004 9/30/2005
11 12/1/2004 3/1/2005
12 12/11/2004 9/30/2005
13 12/15/2004 9/30/2005
14 1/2/2005 9/15/2005
15 11/29/2004 1/27/2005
16 11/29/2004 1/27/2005
17 1/1/2005 4/30/2005
18 1/10/2005 9/30/2005
19 11/20/2004 9/30/2005
20 12/26/2005 9/30/3005
21 1/10/2005 3/30/2005
22 12/1/2004 3/2/2005
23 10/1/2004 12/31/2004
 

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