Add value to label in pie chart?
I've got a pie chart showing ten different values, ranging from close to 50% down to a fraction of a percentage. It's showing labels from the header column in the table, but I want the labels to show both that name and the percentage as well. (I could display the percentage on the pie chart, but then some of the numbers become illegible on the smaller slices.)
How can I do this? I have figured out that I can change the Name field under Wedge -> Data one wedge at a time, but that's a pain, especially since the smaller slices are just about impossible to select. Surely there's a better way?
The data's pretty simple, it just looks kind of like this (though with 10 values instead of just 5):
| Col 1 | Col 2 | Col 3 |
|---|---|---|
| Label 1 | 500 | 50% |
| Label 2 | 250 | 25% |
| Label 3 | 150 | 15% |
| Label 4 | 50 | 5% |
| Label 5 | 25 | 2.5% |
So, ideally, I'd like each label on the pie chart to show as something like "Label 1 (50%)"
macOS Sierra (10.12.2)
