Hi everyone,

I received an excel spreadsheet with absence dates, reasons, departments and genders and i need to create 5 different charts for analysing the data. This is a school assignment and it is my first time doing charts.
I need to create 5 different charts:
[*] trends across departments[*] Absence by type[*] absence by gender[*] total days lost[*] annual total costs

When i select the whole row of data, for example the gender, then click on insert, then charts, it does bring out the chart but it doesnt show the data or when it does show the date it is crumbled together on the top.

How do i make the requested charts out of this data correctly?