Once you have your dataset sorted out, do the following: 1. Select the Speedometer column values. 2. Go to the Inserttab. 3. Click the Insert Pie or Doughnut Charticon. 4. Choose Doughnut. Remove the legend. 展开

Next, you need to adjust the position of the chart to lay the groundwork for the future half-circle gauge. 1. Right-click on the doughnut chart body and choose Format Data Series. 2. In the pane that appears to the right, set the Angle of first slice to 270° and the Doughnut Hole … 展开

To turn the circle into a half-circle, you need to hide the bottom part of the chart. Think of the dial chart as the tip of an iceberg while the half … 展开

Once you’ve positioned the doughnut chart properly, click the Fill & Line icon in the pane, navigate to the Border section, and click the No line radio … 展开