The score meter chart template is a smart chart that helps you to display values on a quality scale. Are you want to show your KPIs using a dynamic chart? You have to follow only a few steps! The template is based on multiple stacked bar charts. First, create a simple table for your data set. Split the range (from 0% to 100%) into five areas, like poor, uncertain, fair, good, and excellent.
You’ll use an array formula to decide that in the FREQUENCY column, what value will correspond to the actual value. Apply a custom color scale for each section from red to green. Your chart template is ready to use!