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.

You could leave the chart as is, as a combo chart, as shown in Figure D, but let’s remove the lines so it’s strictly a floating bar chart. Figure D To finish the Excel chart, delete the lines.

It provides much of the same basic functionality as Excel, and creating the perfect graph for your data is also just as easy. Highlight the range of data you wish to represent in the graph.

How to create the PivotChart in Excel At this point, you have a PivotTable that counts the number of invoices per month and by the year. From here, creating the year-over-year PivotChart is easy: ...

In Microsoft Excel, when creating a graph, it generally has an X-axis and a Y-axis, but with a combination graph, there are two Y-axis which allows the user to have two different types of data ...