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!