In cells C$47-$G$47$ insert a Clustered Column Chart to show the distribution of the registered $($Yes$/$No$)$ across the three political parties. Select the Column Chart and then the Clustered Column Chart from the provided chart options in the Charts group of the Insert tab of the Ribbon. Choose Select Data in the Design tab on the Ribbon. Delete any series created automatically using the Remove button and add a new series using Add button. Add a new series for the distribution of those not registered to vote across the three political parties using cells D$28-$D$30$ as the Series values. Use cell D$27$ to set the series name. Add new series for the distribution of those registered to vote across the three political parties using cells E$28-$E$30$ as the Series values. Use cell E$27$ to set the series name. Edit Category Labels using cells C$28-$C$30$ as the Axis label range. Select design Style $1$ in the Design tab of the Ribbon. Then go to the Add Chart Elements drop$-$down list in the Chart Layouts part of the Design tab of the Ribbon. Add the legend and choose the Right option. Add the data labels and choose the Outside End option. Go to the Format tab on the Ribbon. Set the chart height and width so the entire chart fits within cells C$47-$G$47.$