In this Excel video tutorial, we will learn how to make a thermometer chart in Excel that automatically changes color, step by step, in practice, how to create this beautiful and modern chart in Excel.

Basically, to build this interactive Excel chart we are going to use the stacked column chart in Excel. And we will use, as value for the chart, the value Realized in Percentage.

The percentage values is obtained by dividing the actual value by the target value or the actual value by goal value.

We can also consider this chart as a goals chart in Excel.

#JopaExcel #Dashboard #Excel