Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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 1Col 2Col 3
Label 150050%
Label 2250

25%

Label 315015%
Label 4505%
Label 5252.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)

Posted on Dec 27, 2016 11:10 AM

Reply
14 replies
Sort By: 

Dec 27, 2016 11:55 AM in response to thomas_r.

you can use a formula in the label column to have the label and the corresponding value like this:



User uploaded file


The names of the table indicate their function. The data for the chart comes from the table on the right ("DataForChart") which takes its' data from the table on the left "Original Data".


The first row and first column for the table on the right are headers.


the formulas in the table on the right are:

A2=Original Data::A2&" ("&B2&"%)"


this is shorthand for... select cell A2, then type (or copy and paste from here) the formula:

=Original Data::A2&" ("&B2&"%)"


B2=ROUND(100×Original Data::B2÷SUM(Original Data::B),1)

select cells A2 and B2, copy

select cells A2 thru the end of column B (or as needed), paste


select the data cells for column B. In this example, select cells B2 thru B6

now add the chart.


Now adjust the wedges using the Wedge Formatter for the chart as shown

Reply

Dec 27, 2016 11:09 PM in response to ChitlinsCC

"from Thomas's OPost table...

50% + 25& = 75%

75% + 15% = 90%

90% + 5% = 95%

95% + 2.5% = 97.5%

no more values to add?"


My bad.

I was looking at the table image (which was in Wayne's post, not the OPost table).


Regarding solutions, I think Wayne has nailed it.


Regards,

Barry

Reply

Dec 28, 2016 8:09 AM in response to ChitlinsCC

Hi ÇÇÇ,

Barry wrote:

Regarding solutions, I think Wayne has nailed it.

I have admired Wayne's solutions since I joined ASC in December 2012.

All Time contributors to the iWork forums:

User uploaded file

Welcome to the Numbers for Mac forum, ÇÇÇ. Please join in 🙂.


Regards,

Ian.

Reply

Add value to label in pie chart?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.