Can you attached an example workbook ? Make sure to do a packaged workbook with the data (twbx)
Hello, You can try below approach.
1. Create a new worksheet.
2. Go to Mark type and select pie from drop-down.
3. Drag Location to color and Number of records to angel.
This will give you the result.