Question: The total number of term life insurance contracts sold in Problem is 199. The following pie chart shows the percentages of contracts sold by each salesperson.

a. What are the problems with using a pie chart to display these data?

b. What type of chart would be preferred for displaying the data in this pie chart?

c. Use a different type of chart to display the percentage of contracts sold by each salesperson that conveys the data better than the pie chart. Format the chart and add data labels to improve the chart's readability.

Problem: The following table contains sales totals for the top six term life insurance salespeople at American Insurance.

a. Create a column chart to display the information in the table above. Format the column chart to best display the data by adding axes labels, a chart title, etc.

b. Sort the values in Excel so that the column chart is ordered from most contracts sold to fewest.

c. Insert data labels to display the number of contracts sold for each salesperson above the columns in the column chart created in part a.