For this example, we’ll create a simple worksheet that displays the total July sales of each sales agent on the marketing team, then let Excel create several charts to compare the totals.

The Gauge chart is known as a dial or speedometer chart. Learn how to create a Gauge Chart in Microsoft Excel by following this tutorial.