Thermometer Chart

When I select B21 and insert stacked column chart. My column show only the part of the 64 percent. How to make it look like the chart on the left?

Hello
You can either add a second series with the value of 1-B21, or as seems to have been done on your chart, format the empty Plot Area with a gradient fill.

DBY