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

pie chart values

Hello,


Is there a way to change how a pie chart interprets and sorts data? I want create a pie chart with 3 categories: Less than 10, 10-20, and greater than 20. Say I have a column with different numbers ranging from 1-30 within each cell. Is there a way Numbers can read the values in this column and assign them to the correct wedge/category? So if I had the numbers 7, 12, 16, and 28 my pie chart would read: 25% less than 10, 50% 10-20, and 25% greater than 10.


Thank you!

Posted on Feb 20, 2017 11:54 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 20, 2017 12:19 PM

You will have to create a small table to summarize the data you want to plot:

User uploaded file


The summary table is named "PieChartData" and the original data (as you presented in your post) is in a table named "Table 2". Adjust the table names if necessary.


For the table "PieChartData":

enter the values in column C as shown


make the first column a header column


A2=C1&" to "&C2


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

=C1&" to "&C2


B2=COUNTIFS(Table 2::A, "<"&C2, Table 2::A, ">="&C1)


select cells A2 and B2, copy

select cells A2 thru B4, paste


now select cells B2 thru B4, then add a pie chart from the charts menu


User uploaded file

7 replies
Sort By: 
Question marked as Top-ranking reply

Feb 20, 2017 12:19 PM in response to yvolaco

You will have to create a small table to summarize the data you want to plot:

User uploaded file


The summary table is named "PieChartData" and the original data (as you presented in your post) is in a table named "Table 2". Adjust the table names if necessary.


For the table "PieChartData":

enter the values in column C as shown


make the first column a header column


A2=C1&" to "&C2


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

=C1&" to "&C2


B2=COUNTIFS(Table 2::A, "<"&C2, Table 2::A, ">="&C1)


select cells A2 and B2, copy

select cells A2 thru B4, paste


now select cells B2 thru B4, then add a pie chart from the charts menu


User uploaded file

Reply

Feb 20, 2017 12:30 PM in response to yvolaco

Hi y'


Numbers will chart the information you supply to the chart.

User uploaded file

Original data is on Table 1.


Chart table is used to summarize the information to supply the chart, using three formulas:


B2: COUNTIFS(Table 1::B,"<10")

B3: COUNTIFS(Table 1::B,">=10",Table 1::B,"<=20")

B4: COUNTIFS(Table 1::B,">20")


COUNTIFS is necessary for the two conditions required in B3.

COUNTIF could be used in B2 and B3, where only one condition is needed to establish the range of values to be counted. I used COUNTIFS only to keep the formulas consistent.


Regards,

Barry

Reply

Feb 20, 2017 12:43 PM in response to yvolaco

"I want create a pie chart with 3 categories: Less than 10, 10-20, and greater than 20."


I think you'll find that my version matches your specification more closely that does Wayne's for the category in bold above.


Regards,

Barry

Reply

pie chart values

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