Alright, I'm trying to create a pie chart that shows Locations in the Legend so that each location as a designated color, and the values assigned to each location is TotalSales. I thought it would be an easy thing to implement, but I'm running into issues.
When I implement the code below, it shows the TotalSales all around the pie chart (I know that's because of LabelLocation="Auto") but the legend on the right would just say "Series xx". I know how to get the name to change, but I don't know how to get it to create a new item for each location.
Can someone help me out with this?
Here's my code: