J
John Smith
I am interested in creating a stacked line chart that will display my
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
Below an example of the data that need to be in the spread sheet. Thanks.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.
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