In my example, I created the ball using a line chart with markers. The marker you then change into a ball. The size of this ball you can increase. And it's done. You can then smoothly increase the number of thermometers.
You can download the example file ExcelThermometer.xlsx via