![]() I could just do equals and then click there and get that number.īut instead I'm going to use an IF function. Then I'm going to do the same thing here. ![]() In other words just give me a copy of what's there. So I'm going to do equals and I'm just going to click here where it says apples. I'm going to do Items and Sales again, I don't need all those there, and I'm going to do some formulas. I'm going to create another table here, and this table, let's put it next to it, I'm going to do something similar. So I'm going to do equals, SUM for sum, click on the heading there and now I have a total for all sales, that's going to come in handy. I want to switch that to a footer row and get a total. I'm going to go back to the table and I left an extra row here for a reason. But I figured out a way that you could do it and kind of keep updating things and it would work. But there really isn't an option to do that. Typically you'd want to group these all together and then define them as Other. Notice I've got some very narrow wedges here. Since I had this selected it populates it with all the data. Suppose you have a chart like this where you have various items with numbers next to them and you want to create a pie chart. Video Transcript: So here's something I was playing around with in Numbers. Check out Creating Pie Charts In Numbers With an Other Slice at YouTube for closed captioning and more options.
0 Comments
Leave a Reply. |