Excel Pie Charts by Representative
Budget: ₹12,500 – ₹37,500 INR
I’m sharing a raw transaction-level Excel workbook and need it turned into clear, attractive pie charts that break down total sales by each sales representative. The file is already packed with every individual sale; what it lacks is an easy-to-read visual summary.
Here’s what I’m after:
• Clean the relevant columns only if you must (dates, rep names, amounts) so the numbers add up correctly.
• Build one or more pie charts that display each rep’s share of overall revenue.
• Keep the look professional but presentation-ready—labels, legends, and percentages should be obvious at a glance.
I work in standard Microsoft 365, so the final visuals must sit comfortably inside that environment and update automatically if I change the underlying data. A quick walkthrough of how you set up the dynamic range or pivot would be appreciated so I can refresh the chart later without extra help.
Once the pie charts are polished and the file returns error-free, we’re done.
Here’s what I’m after:
• Clean the relevant columns only if you must (dates, rep names, amounts) so the numbers add up correctly.
• Build one or more pie charts that display each rep’s share of overall revenue.
• Keep the look professional but presentation-ready—labels, legends, and percentages should be obvious at a glance.
I work in standard Microsoft 365, so the final visuals must sit comfortably inside that environment and update automatically if I change the underlying data. A quick walkthrough of how you set up the dynamic range or pivot would be appreciated so I can refresh the chart later without extra help.
Once the pie charts are polished and the file returns error-free, we’re done.