Funny thermometer Cocktail chart
To create the chart like this one, do the following:
1. Create a rainbow thermometer chart (in this example, for cells C19:C23):
2. The trick of creating charts like this one is to have a transparent picture in your worksheet:
2.A. If you have a picture with gaps inside:
- just insert it:
- and move it to the front of the chart:
2.B. If you don't have a picture with gaps inside, you can create it:
- just crop parts of the picture:
- group them and move it to the front of the chart:
Make any other adjustments to get the look you desire.
See also this tip in French: Comment créer un graphique de thermomètre Cocktail.