Graphs

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?

šŸš€ Scriptcase 9.12 is now available! Check out the new features here šŸ‘‰šŸš€ Next Monday (02/24), Scriptcase 9.12 will be released! Check out the new features before anyone else šŸ‘‰