Return to the Sales Table worksheet. Sonia wants to compare the average revenue generated by insurance agents based on their years of experience.

Insert a PivotTable and PivotChart on a new worksheet, using Average Revenue as the worksheet name. Make sure the 'Add this data to the Data Model' checkbox is unchecked. $[$Mac hint: There is no checkbox, so Mac users can ignore this.$]$ With the blank PivotChart selected, add the Years Experience field to the Axis $($Categories$)$ area, Revenue $2023$ as the first Values field, and Revenue $2024$ as the second Values field. Change the value field settings of both value fields to display averages, using the Currency number format with $2$ decimal places and the $ symbol. Change the PivotChart layout to Layout $3,$ and use Revenue by Years of Experience as the chart title. Move and resize the PivotChart so that its upper$-$left corner is in cell A$9$ and its lower$-$right corner is in cell C$24.$