The file named Problem24data.xlsx contains position and salary data for 2016 Carolina Panthers NFL players. Create a drop-down menu from which a player can be selected. Then create formulas that show the player’s position and salary. Finally, create a pie chart based on the PivotTable that shows the percentage of salary paid to each position. When you add new data and refresh your PivotTable, all your work should automatically update.