The Thermometer chart is not a default chart in Excel or any Office programs; you have to create one from scratch. For this, you have to use the bar graph and shapes available in Microsoft Excel.

Figure B The Excel add-in inserts a chart populated with dummy data. How to connect the Excel data to the chart At this point, you’re ready to connect the chart to real data.

By using Excel or Google Sheets to create impactful graphs, you'll be able to captivate your audience, facilitate meaningful discussions, and drive home the key points of your presentation.

Figure H Our new PivotChart. This type of chart provides a lot of information, and thanks to Excel’s two pivot objects, you won’t have to jump through hoops to produce it.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

Learn how to create a Combination Chart in Microsoft Excel. We also show you how to to combine bar and line graph & create Custom Combo Chart.