Salesperson Sales Bar Chart

I have an Excel workbook with raw transaction records and I need a clear, refreshable bar chart that shows the total sales amount for each salesperson. The job is straightforward: prepare the data inside Excel—using Pivot Tables or Power Query if that makes the workflow easier—and build a bar chart that updates automatically whenever I paste in new rows. Please return the same workbook with the cleaned data structure and the finished chart, nicely formatted with readable labels and a legend. Keep everything inside Excel; no external BI tools are necessary. I’ll share the file as soon as we start and can clarify any field names you need before you dive in.