Let’s start out our grand adventure by creating a dataset for both charts.
The doughnut chart will become the speedometer while the pie chart will be transformed into the pointer. Technically, a gauge chart is a hybrid of a doughnut chart and a pie chart overlapping one another. Step #1: Prepare a dataset for your gauge chart. Without further ado, let’s dive right in. Here’s an example of the gauge chart you will learn to build from scratch: However, Excel’s massive bag of built-in visualization tools unfortunately has no ready-made solution to offer for such a chart.īut with a bit of spreadsheet magic, there is no obstacle you can’t surmount. Gauge Charts (also referred to as Speedometer or Dial Charts) save the day when it comes to comparing KPIs or business results against the stated goals. Bonus Step for the Tenacious: Add a text box with your actual data value.
#HOW TO CREATE PIE CHART IN EXCEL WITH WORDS HOW TO#
Return to Charts Home Excel Gauge Chart Template – Free Download – How to Create Create, Save, & Use Excel Chart Templates