Up next in 10
Create a Speedometer Chart in Excel
174K views
Jul 6, 2024
"Explore Exciting Chart Options in Excel: No Speedometer? No Problem! Discover how to craft a stunning speedometer chart in Excel using doughnuts and pie charts. Join us in this tutorial as we unlock the secrets to creating an impressive and functional speedometer chart that will elevate your data visualization game!"
View Video Transcript
0:00
Let's create a really impressive speedometer chart by using a combination of donuts and
0:05
pie charts. Please input the following values into cells B2 to B5 of series 1, 180, 45, 90, and 45, respectively
0:17
And then input the following values into cells C2 to C13 of series 2, 180, 9, 18, repeated
0:27
from cells C4 to C12 and 9, respectively. Next, highlight the range C2, C5, go to the Insert tab, and click the Recommended Charts
0:40
icon in Charts group. The Insert Chart dialog box will be displayed
0:45
Choose Pie from the All Charts tab. Select the donut and click OK button to insert the chart on the worksheet
0:53
Next, select the donut chart, right-click on it, and choose Format Data Series from
1:02
the context menu. This action will display the Format Data Series pane on the right side of the worksheet
1:09
Navigate to Series Options within the Format Data Series pane, then adjust the Angle of
1:13
First Slice value to 90 degrees. Slowly double-click the largest slice to select it, then click on the Fill and Line icon
1:22
From the Fill and Border options, choose No Fill and No Line to hide the slice
1:28
Right-click on the chart and choose the Select Data option to add another series
1:33
Click the Add button within the Legend Entries tab. In the Series Values box, select the cell range B2 to B13 and click OK button
1:50
Click OK button again to close the Select Data Source dialog box
1:57
Slowly double-click the largest slice of Series 2 to select it. Then set both the Fill and Border options to No Fill and No Line respectively
2:08
These two series were for displaying the speedometer dials. We will now proceed to create the primary graph by introducing a third series
2:16
This series will serve to indicate the speedometer needle's position relative to the provided
2:20
speed value, aligning it with the corresponding speed label on the graph
2:28
In the cell E2, insert the speed value you want to show on the graph, for example 20
2:33
Also insert value 150 in cell D2 and value 2 in cell D4
2:39
The value 2 defines the thickness of speedometer needle. In cell D3 insert the formula that multiplies the value of the cell E2 with 1.8 and then
2:50
subtracts 1 from that result
3:05
In cell D5 insert the formula. That subtracts the sum of the values in cells D2 to D4 from 360
3:23
Now right-click on the chart and choose Select Data option, then click the Add button to
3:28
add a third series. Under the series values, select the range D2, D5
3:34
Press OK button to return back to the Select Data Source dialog box
3:42
Click OK button to save the changes. Highlight the newly added series, the outer series, then right-click it and select Change
3:52
Series Chart Type. Change this series to the default pie chart. Yes, it looks strange
3:59
But rest assured, if the pie chart overlays the donut chart, you have done this correctly
4:07
Select the chart and in the Format Data Series pane, change the angle of first slice value
4:12
to 120 degree. Next you need to hide all the slices of pie chart you just laid over the donut except
4:22
the smaller one. Select each section of the pie chart one by one, two slow clicks on the desired slice
4:29
will select the slice. And click Fill and Line icon on the right pane and select No Fill from the Fill section
4:35
and No Line from the Border section. Next, choose the smallest chart slice and customize its color to your preference
4:59
Next, we will add the chart labels, which will be visible on the speedometer dial
5:24
Now insert the value 0 into cells A2 and A3. Then input values from 10 to 100 incrementing by 10 into cells A4 to A13
5:41
Again, right-click on the chart and choose Select Data option
5:53
Click Edit button under the Horizontal Category Axis labels and select the A2 to A13 range
6:07
Now select the Series 2. If encountering difficulty, select the chart and from the Format Data Series pane, click
6:14
the Series Options dropdown and click the Series 2 to select it
6:22
Now go to the Chart Design tab and click Add Chart Element from the Chart Layout group
6:28
Choose Data Labels from the menu and select the Data Callout from the submenu
6:33
Speed labels will appear around the chart. Slowly double-click the bottom label to select it and then proceed to delete
6:40
Now select the chart and click on any label to select all labels
6:45
Then navigate to the Format Data Label pane. Uncheck the Percentage box from the Label Options section
6:52
Then click the Fill and Line icon and choose No Fill and No Border to display only the
6:57
numbers without the Percentage and Callout box
7:06
Now proceed to manually adjust the position of each label to emulate the appearance of
7:11
a speedometer on the chart. Lastly, modify the value of cell E2 within the range of 0 to 100 to observe the final
7:55
result on the speedometer chart. Notice the needle is not clearly visible due to the white borders around the pie chart slices
8:18
To rectify this, select each slice individually and opt for No Border from the Format Data
8:24
Series pane. By following these steps, you can create a visually appealing speedometer chart in Excel
8:33
Experiment with different values and adjustments to customize your chart to suit your needs
8:38
Have fun charting your data with style
#Business & Productivity Software
#Computers & Electronics
#Education
#Other
#Software