Jean,
sorry, it has not help.

Paul
"Jean Ruch" wrote in message
...

"PR" schrieb im Newsbeitrag
...
I am looking for a way to create a chart over a year period by each
week, to
let me now how many people where in my organisation over a year
period, The
problem I have is that I only have a start and end date. i.e.

p1 01/01/04 - 31/01/04
p2 21/01/04 - 01/02/04
p3 07/01/04 - 24/01/04
p4 10/01/04 - 25/01/04
p5 12/01/04 - 19/01/04

I would like to see a table like this to create a chart.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
25 26 27
28 29 30 31
p1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1
p2 1 1 1 1 1 1 1 1 1 1
1
p3 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
p4 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
p5 1 1 1 1 1 1 1 1
1 1 1 1 1 1 2 2 2 3 3 4 4 4 4 4 4 4 4 3 4 4 4 4 3 2 2 2 2 2 2


can anyone help.


Hallo Paul,

I understood you differently from Lance.
To make your chart, instead of taking a series of NUMBERS 1,2,3, for
your x Axis, take real DATES
(01.01.2004, 02.01.2004, etc )
Make a stacked column chart of your data's including the row headers
p1, p2, p3 etc...
Does it come nearer to what you want ?

regards

Jean