Pie chart data labels

I need to add the number of each item to the end of the label for each segment

e.g. I have a pie chart consisting of:

3 sheep
2 pigs
1 chicken

I need the pie chart labels to show the numbers, so appear as

sheep (3)
pigs (2)
chicken (1)

rather than just

sheep
pigs
chicken


There must be a way of doing this without having to do it manually?

Thanks!

Thanks! This places the number inside the actual chart itself, is there any way to have it appear in the labels in the legend?

From your post title I assumed you meant the chart data labels. If you want the legend to have the numerical values then you'll probably have to concatenate the categories with their values and use those as the categories for the chart. For example:

Formula:

Please Login or Register  to view this content.

If the category was in A2 and the value in B2. Copy down for the other categories and values.