How to create a epi/count by day cluster graph

Hello, 

I wanted to create a dynamic graph that will show a daily count of the number of positive residents and staff (stacked bar graph ) that indicates the number of each reported positives each day/ . the date will come from the episode date (second to last row in photo). because the data will be entered in on a daily basis I want to make sure when the graph auto populates axis's change was well.