Problem: Trying to Collect Data from spread sheet and converting it into a graph(s)

Hey, I've got a spreed sheet for work to keep a record of days worked, and wat i was doing.
and a 2nd sheet to show it in simpler terms, but i would like to now edit it to show a few diffrent graphs based on the information, and dont know how to, any help would be good, ill attach a copy of what i have.

Looking at making a graph for the following.

Pie Graph: to show the diffrance between A and B Grade work.

A graph(S) to show the most commen day mon-fri for sick leave, annual leave, and RDO's (diffrent graphs for each probably, ot maybe in the one? dunno)

and a graph to show what days are getting the highest carcuss count.. if possible?

thanks in advance for any help i can get, cheers,

How you make your pie chart... (I'm using Excel 2010) ... Highlight the cells you want to be included...

on the top menu, choose insert, then pie chart.

You'll have to play with it a little as the way you currently have it set up... data doesn't match up perfectly. (your annual)