Flippity provides a handful of great Google Sheets templates. I've featured their Random Name Picker, Flashcard, and Jeopardy templates in the past. 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. In the video embedded below I provide an overview of how to use Flippity's Progress Indicator template.