Follow the steps below to create a thermometer chart in Excel. Draw the oval shape at the bottom of the chart. Click the Shape Fill button and select a color that matches the color in your chart. Now, ...