As you build your spreadsheet with the data you've selected from the reports, you start to wonder what would be the best chart type to use for this data. The most important chart will show each day of the week and the number of unplanned absences throughout the year that occurred on that weekday.