Chart from a calendar
I'm just starting on my SharePoint journey. I'd like to put a calendar of events I've got booked on my site, which is fairly simple, I've worked that much out. Below this I'd like to put a column chart showing how many events I've got booked in each month. I know I could possibly export the calendar as a csv, then come up with a way of doing a count, or even a pivot chart in excel and maybe import that back into SharePoint, but I was hoping for a more dynamic solution, where the chart would be linked to the calendar, and would update as new events are added. Is this possible?