Check out Creating Charts In Numbers at YouTube for closed captioning and more options.
Creating Charts In Numbers
Comments: 7 Responses to “Creating Charts In Numbers”
Comments Closed.
Check out Creating Charts In Numbers at YouTube for closed captioning and more options.
How do I create a pie chart with more than 5 colors? I need 7 colors and do not want to repeat any of the 5 that Numbers gives me.
Thank you in advance.
Mary
You can do it in the Format, Style inspector sidebar. Just select the wedge first. It is tricky, so try selecting different wedges and experimenting. AT first all of the wedges of that color will change, but if you do it right, you can change them individually.
Lets say in your example with the pie chart I have some more fruits (lemon, lime, grapefruit). In order to keep the chart clean I want all citrus fruits show up as only one wedge. In the old 'numbers' I could just add cells in the 'value' field for a particular wedge. In numbers 3.1 It always defaults back to the original one field.
Actually in an imported file it even defaults back to the original sum of two fields. It looks like it is not possible to change the source field for a wedge.
I would create a new table alongside your main one that has exactly the data in it that you want in the pie chart. Use references and SUM formulas in this second table so it updates automatically.
I created a new spreadsheet and pasted that formula in all the cells that have data of the spreadsheet I am trying to transpose, but it just gives me a bunch of blank or some zeros...and yes I used the paste formula results. Should the $A$1 value match the cell that it is entered into? So for C4 should that be C4 and not $A$1? Thanks for much for your help...love your videos. Totally stuck right now