"Jean Ruch" schrieb im Newsbeitrag
...
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...
Hello Paul,
To make the TABLE on which your chart is based:
Assuming your Entry "p1" is located in A5; "p2" in A6; "p3" in A7
etc...
and correspondingly the first day of work in Column B
the last day of work in Column C,
This whole basic Data beeing in the Range A5:C9
make a Date series in the Range F 10: AJ 10
(for ex. beginning with 01.01.2004 in F10 and ending with 31.01.2004 in
AJ 10 )
Put the following Formula in F11
=IF(F$10<$B5; ""; IF(F$10$C5;"";1))
copy and insert it on all the concerned cells.
be cautious about the semicolon (german Excel); may be it is different
for you ?
regards
Jean
|