Next, you need to adjust the position of the chart to lay the groundwork for the future half-circle gauge.
Click the Insert Pie or Doughnut Chart icon. Once you have your dataset sorted out, do the following: End: This special formula- =200-(E3+E4)- will help position the pointer properly by adding all the cells from the Value column ( 30+40+30+100) and subtracting from that sum ( 200) the pointer width ( E4) and your actual data value ( E3). In our case, we will display how much money a fictitious company earned from its sales in Arizona. Value: This is your actual data value. You can change the width however you see fit, but we recommend making it smaller than five pixels. Pointer: This determines the width of the needle (the pointer). The more detailed you want to display your data, the more value intervals you’ll need. Levels: These are the value ranges that will split the dial chart into multiple sections. Labels: These determine the intervals of the gauge chart labels. Prepare your spreadsheet as follows:Ī few words about each element of the dataset: 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.
Return to Charts Home Excel Gauge Chart Template – Free Download – How to Create Create, Save, & Use Excel Chart Templates
0 kommentar(er)
