Creating a rainbow thermometer chart
![The thermometer Chart Excel 2016 The thermometer Chart Excel 2016](/images/tips/340_2016/1.png)
For example, a worksheet set up to track daily progress towards a goal: 1,000 new sales in 10 days. Cell C16 contains the goal value, and cell C17 contains a simple sum formula:
= SUM (C5:C14)
Cell C19 contains a formula that calculates the percent of goal (see Creating a simple thermometer chart):
= C17 / C16.
To create the chart like this one, do the following:
1. Add additional data to see different colors for different intervals (in this example, cells C20:C24):
![Additional data Excel 2016 Additional data Excel 2016](/images/tips/340_2016/2.png)
2. Select cells C20:C24.
3. On the Insert tab, in the Charts group, choose the Column button:
![Column Charts in Excel 2016 Column Charts in Excel 2016](/images/tips/excel_button2016/column_chart.png)
Choose the 100% Stacked Column
chart.
4. Do one of the following:
- Right-click in the chart area. In the popup menu select Select Data...:
Then in the Select Data Source dialog box, click the Switch Row/Column button:
- Under Chart Tools, on the Design tab, in the Data group, click the Switch
Row/Column button:
5. Right-click in the data series and choose Format Data Series... in the popup menu:
![Format data series in popup menu Excel 2016 Format data series in popup menu Excel 2016](/images/tips/excel_button2016/format_data_series.png)
6. On the Format Data Series pane for every series choose different colors. You can choose different series by selecting each data series on the chart or in that pane:
![Choose series in Excel 2016 Choose data series in Excel 2016](/images/tips/340_2016/4.png)
Make any other adjustments to get the look you desire.
See also this tip in French: Comment créer un graphique de thermomètre arc-en-ciel.