The following table contains sales totals for the top six term life insurance salespeople at American Insurance.
Salesperson Contracts Sold
Harish…………………………… 24
David……………………………….. 41
Kristina……………………………….19
Steven………………………………..23
Tim……………………………….. 53
Mona……………………………….. 39
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.