Hi,
I have a Google Sheet that tracks students, and their enrollment and withdrawal date for a school.
I want to make bar chart that shows counts of enrollments and withdrawals grouped by month/year for each month. Screen shots below of my Google Sheet and a mock of the chart I want to create.
I've been struggling to sort out exactly how to make this chart since I am counting two different date dimensions.
Bonus points if you can figure out how to add a 3rd bar to each month showing the aggregate number of enrollments for each month. That's not a priority but a "nice to have" if you can provide guidance.
I'd be happy with a bar chart that showed positive counts for each as well - showing withdrawals as negative is a nice-to-have.