Flippity provides a handful of great Google Sheets templates. The latest Flippity template that I’ve tried is their Progress Indicator template. With that template you can create a progress chart that will update whenever you update the data in the chart.
http://www.freetech4teachers.com/2015/08/how-to-create-progress-chart-in-google.html