Time series bar chart displaying counts of two different fields side-by-side.

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. Data-Students.pngChart-Example.png

0 1 55
1 REPLY 1

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. 

Top Labels in this Space