Right click on the biggest point, and click Format Data Point in the context menu.Ħ. In the opening Format Data Series pane, type 271 into the Angle of first slice textbox and close the pane.ĥ.
Right click the doughnut chart and select Format Data Series from the context menu.ĥ.
Select data in the Value column, click Insert > Insert Pie or Doughnut Chart > Doughnut. Go to the blank range next to the Value column, and type 10 and 5 separately into D2 and D3, and then copy the below formula into cell D4. Here I will separate the speedometer into three parts, so I type 30, 60, 90 separately into A2, A3 and A4, then in the cell A5, type the total number of numbers that typed in the above three cells.
0 kommentar(er)
