This chapter illustrates how create a Gauge Chart. A gauge chart (or speedometer chart) combines a Doughnut chart and a Pie chart in a single chart. This is what the spreadsheet looks like. To create a gauge chart, execute the following steps. 1. Select the range H2:I6. Note: the Donut series has 4 data points and the Pie series has 3 data points.…