How to Create a Gauge Chart in Excel?

Gauge chart is also known as a speedometer or dial chart, which use a pointer to show the readings on a dial. It is just like a speedometer with a needle, where the needle tells you a number by pointing it out on the gauge chart with different ranges.

It is a Single point chart that tracks a single data point against its target.

Steps to Create a Gauge Chart

Follow the below steps to create a Gauge chart:

Step 1: First enter the data points and values.

Step 2: Doughnut chart(with First table values).

• Select the range B2:B7
• Then press shortcut keys [Alt + N + Q and select the Doughnut] or Go to Insert -> Charts -> Doughnut (With these steps you will get a blank chart).

Step 3: Delete or hide the left portion of the Doughnut chart.

• Select the chart (left click on the chart) & double click on the left portion.
• Then right click -> format Data point… -> paint -> fill -> select “No fill”.

Step 4: Change the Angle

• Select the legend Icon & Change the angle to 271.
• Then you can change the doughnut hole size.

Step 5: Set the Border & color

• Go to fill and line -> border -> No line.
• You can also change the colors of each data point.

Step 6: Creating a pointer

• Click on the chart -> Chart Design -> Select Data -> Add

• Series name as a Pointer or Thickness(for this first select first box and A11)
• Then for “Series values” select the values, here, selected 36, 5 & 153.

• Select “OK“.

• Now select the new chart and make it “No Fill” except the pointer(The smaller data point).

Step 7: Change chart type.

• Select chart -> chart Design -> change chart type -> combo. Then for series chart select Doughnut.

• Same as series select pie chart Type for “thickness” Then Select “Ok”.

• Now the last Step is to change the angle of the chart as 271.
• Give Data Labels.

ayonssp

Follow

Improve

Article Tags :

• Excel
• Microsoft Office
• News
• ExcelGuide