Monthly Spreadsheet with Graph

I have a spreadsheet that I do each Month. However, I want to be able to generate the graph each month based on the creation of the data.

i.e for October, November (different set of days ect 30,31. I want to have the graph auto generate based on monthly worksheet and really dont know how to approach this. any ideas or samples would be appreciated, sorry if it's basic!