Click the Add button and Name the new series “Needle.” Navigate to the Series values field and select the Position, Needle and End data. Right click the gauge chart you just created and choose Select Data. Finally right click the wedge on the bottom and choose Format Data Series. Next, change the doughnut Hole Size to 50%. First, change the Angle for first slice by typing in the number 270 and pressing Enter. We’ll make two changes in the next dialog box. Right click the chart and choose Format Data Series. Modify the chart to look like the half-circle dial.For this activity, it’s best to create the chart in the same worksheet as the data to make all the necessary modifications easier. Note: While you can use the F11 shortcut to create a chart. In later version, you’ll find it in the drop down button for Pie Charts. You’ll find this in Excel 2010 on the drop down button named Other Charts. Select the 7 cells for your Speedometer and insert a Doughnut Chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |