How to create excell chart to reflect attendence rate?

Hi.
I'm totally at lost for creating excell chart : the type i should use and the data configuration
First of all i explain my need:
1) Attendence record for dept by weekly basis but need to show if its not full attendence
2) Attendence record for dept by mthly basis and also reflect emergency leaves and Medical Clearances.

I attached a sample data. hope that helps. sorry its a bit confusing.

i need 2 type of chart.
I had posted previously but because i didnt attache my excell sheet it is not solved. hope this time the information i give is enough

http://www.excelforum.com/excel-prog...ml#post2489673