Creating Charts In Numbers

You can use data in your spreadsheet tables to create colorful charts of many different types. Learn how to quickly create a chart and modify its look. You can also put charts on separate sheets to make them easier to share and print.

Comments: 7 Responses to “Creating Charts In Numbers”

    Mary
    5 years ago

    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

      5 years ago

      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.

    Sascha
    5 years ago

    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.

      5 years ago

      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.

    Jeff
    5 years ago

    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

Comments Closed.