Ok, this is a part I’m not very familiar with.
I have a table containing department, year/month and percentage absence.
I need to create some reports and graphs from it, but not quite sure how to start:
First: I need a grid with on the x-axis the departments and on the y-axis the months. This way I can present a comparable sheet containing absence percentages for each dept and month in one sheet.
Second : I would like to be able to create graphs from this. I need to be able to show a line graph for all departments in one graph
Third: I would like to be able to draw a chart without showing the grid with data first. I want to be able to show a graph of absence percentage of a certain department to show in a dashboard when the manager logs on.
Who has some clues for me?