amazing. this was SO well-explained. I was trying to create a pie chart to help my friend log the intensity of his migraines over time and this help TREMENDOUSLY. potential life-saver. thank you.
You sir, are a genius! We’re always told to RTFM but having someone like you explain clearly makes spending the time watching your vids.so worth it! Kudos and Happy New Year!
I'm doing a spreadsheet for my finances and I wanted to make charts of the data. I unfortunately have 3 different bank accounts so that's 3 checking and 3 savings. I have 4 401k's I have several IRA's and Roth IRA's so you get the picture. These accounts have their own line on the Numbers spreadsheet and I was hoping to be able to assign a "category" to each item and make a clean chart. For example The Bank of America IRA, The Credit Union IRA could both be put under a "IRA Category" and the same with everything else having their own categories so I can make a graph that shows only the categories and not all the different individual accounts. Thanks again for all your videos I've been watching for over a decade.
Hi, I have question. What if a customer orders 2 different pies? As if there are 2 pies in one cell separated by comma, e.g. "Blueberry, Apple" written in cell T1::B2. How to make the program still count that as individual pie instead of combining those value? I came across this problem when I exported data from a survey I made using Google Form.
I've populated my values via links to cells in other worksheets and I just can't seem to get the pie chart to work. It looks just like a two-column table, however the data column refers to the cell in another work sheet. Can anyone help with this?
I can't get the category count function to work, it just counts the number of actual categories, rather than the number of entries within each category, any thoughts? To add, i'm getting the same problem using the countif function
Are you allowed to edit the number of colors used in pie charts, lists, etc? The maximum amount currently appears to be 6 colors allowed. Is there a way to increase that number? Standard colors appear to be "Blue, Green, Grey, Orange, Red and Purple"
What if you want to make multiple pie charts from different data sets within a single table? I have a table with 11 columns and I need to make pie charts for 6 of them which seems to eliminate the category option. Is my only chose to do counts separately then chart?
You can select a set of cells and do a pie chart on just those cells. So you can make multiple pie charts from the same table, sure. Not sure what you mean by your last sentence.
Hi Gary, My table has about 5,000 rows that can be separated by 15 categories.Some categories may include over 1,000 rows. When I follow the guide I end up with a concise table with 2 columns: name, sum. When I click on the table to create a pie chart I get the message "A chart can’t have more than 300 series. Try again with fewer selected cells.". Is there a limit to how big your table can be to use the "easy method"?
That makes sense. Think of how small some of the slices would be in a pie chart with hundreds of items in it. Not very useful. So what is it you are trying to do, exactly?
@@johnscibal So create another table that has those group totals in 15 rows using SUMIF functions. Or, use a Pivot Table to do it without functions if you prefer.
Can you count something that doesn't fit the exact description? For example every discription that has 'pie' in it: creampie, apple pie --> counted as pie. And everything that has 'book' in the description, for example 'workbook', textbook'... --> counted as book. Or does it has to be the exact description to be counted?
You can add a new column for "type" and put "pie" or "book" in there and use that. You can use functions to test the other column for conditions (whether "pie" or "book" is in the text) to do it automatically if you are good with functions.
Awesome job! I have a question: When I am doing a normal bar graph where I am comparing two things, such as a goal and actual #s, when I add the actual #, it makes my goal go higher even though I have a set amount in there. Any thoughts?
Anyone know how to do the pie charts on the iPhone??? I’m trying to do a simple budget but have added more categories and would like a pie chart but can’t seem to get it to work
@@macmost hey I’ve managed to get a pie chart but was wondering if there was a way to pick certain colours for each slices of the pie? It’s only using 4/5 colours at the moment and I’d like to break it down further. Thank you for speedy reply, much appreciated
Thank you so much for this tutorial..your explanation is very clear. I have created categories for numerous cities in my database BUT when I click to create a pie chart, I get an error message that a chart can not have more than 300 series. I am trying to show how many occurrences for each city in a particular state. My entire spreadsheet contains around 8,600 rows of data...HELP
@@macmost thank you for your quick response...there are numerous cities that are repeated across the 8;600 rows of data, so the “categories” filter counted the number of occurrences for the various cities...now I am trying to get those totaled city “categories” to appear in a pie chart...I just now tried selecting (rather than the entire table) only the cells in the table with the city name and the category total for each city and then selecting a pie chart....that SEEMS to get me closer to what I am looking for than anything else I’ve tried over the last 5 hours...i had been trying to do this in Excel with no success...I knew nothing about the Numbers application on my MAC and did not know it was comparable to Excel I thank you again for your excellent tutorials! I will attack this again tomorrow on a “refreshed brain”
Yes. You can use AppleScript or JavaScript to automate all sorts of things, not just in Numbers but other apps too. In fact I have a video coming out tomorrow that uses JavaScript with Numbers.
Thanks for the vid! Currently having an issue where when I’m using a drop-down menu for the list of choices; you can categorize the column and set the count like in this video and it reflects on the piechart but it doesn’t update new data. The chart only updates the list of options that were already selected in the drop-down menu..so if I have 5 rows, and in the column A for each cell I have a drop-down list of 6 options. Let say I added the column A reference to a chart after setting the category and count feature. If at that moment I had 3 of “Option 1”, 1 of “Option 2” and 1 of “Option 3”, the chart will read 60% Option 1 , 20% Option 2, and 20% Option 3 (which is correct). Now when I update any of my selections in that column, for it to reflect on the chart I can only choose between Option 1-3. I can also add new rows and it will reflect as long as I don’t choose between Option 4-6. Is there an way to have the chart to do a complete refresh of its references every time I update a cell in that column? Or a way to give the chart a preset of data (drop-down list options) rather it only recognizing the selected options of the column cells? Should I be sending this message to Apple tech team?🤔
So you are using Categories, and then you add a new category, and the chart doesn't update. Yes, that's just the way it works now. You need to click Edit Data References under the chart, and then click the cell with the value you want to add to add the new category summary.
@@macmost no, I only set up the Category feature once…In column A, each cell have a pop-up menu (drop-down list) of 6 options. I have only 3 of the options (Options 1-3) chosen in the table. Then I go setup the category and the count feature. It works fine. I then go add the reference of column A to the pie chart. I can add more rows and change the options from the pop-up menu in the individual cells without a problem. The category and count feature updates on the table itself correctly, whether I chose any of options 1-6. However the pie chart only updates if I chose between options 1-3, once I start picking options 4-6 the chart doesn’t update correctly.
@@thewld2 Sorry, I don't know what the problem could be then. I'm able to add more values to column A and use Edit Data References to then add that category value to the chart.
@@macmost ima give an example of a real scenario. Let’s say it’s a budgeting spreadsheet. I have a table of expenses. Column A is the “Name” of the expenses. I have let’s say 3 expenses: Rent, Food, Car Note. Now in Column B I have the “Type” of expenses. So each cell have a pop-up menu of 5 options (Lifestyle, Entertainment, Insurance, Home, and Debt). So for “Rent” -> “Home”, “Food”->”Lifestyle”, “Car Note”->”Debt”. Now I setup the category for Column B and setup count. Home reads 1 count, Lifestyle reads 1 count, Debt reads 1 count. I then go setup the pie chart to reference Column B. The chart will read 33% Home, 33% Lifestyle, 33% Debt. If I change Food->Home, the table will read 2 Home, 1 Debt and the chart reads 67% Home, 33% Debt (which is correct).…now this is when it starts breaking down. If I change any of the 3 expenses to “Insurance” or “Entertainment” the table will update correctly but not the chart. So let’s say, change Food->Insurance, table will read 1 Home, 1 Insurance, 1 Debt, but the chart will read 50% Home, 50% Debt. It’s doing this because when the reference was setup, only “Home”, “Lifestyle”, and “Debt” was selected for the 3 expenses. It never recognized the unselected options “Insurance” and “Entertainment”… I can add more rows (expenses) and as long as for Column B I choose between “Home”, “Lifestyle” and “Debt” the chart will update correctly. But as soon as I choose an option (Insurance, or Entertainment) it hasn’t seen before when the reference was setup, it will break. The table however works fine, with no issue.
@@thewld2 Not sure what to suggest. Maybe use a second table instead of Categories. Have that table do your calculations and also generate the chart from it.
@@macmost I have a category with years and a subcategory with months, I would like the chart show the months, but if a select the column I only see the years.
@@ma_rio01 So I assume you have the subcategories set to show subtotal, average or something like that, right? Create the pie chart. Click the Add Chart Data button. Then click each of the 12 months' subtotals to add them as 12 wedges on the pie chart.
Awesome videos.... How about a video on searching the contents of an external drive. I have done what is found on the internet. However, none of it works.
You shouldn't have to do anything special to search an external drive. Just a regular search should turn things up. If you want, start at the top level of that drive in the Finder and search from there to narrow the search to that drive. If that doesn't work, then is the drive formatted any way special?
Can anyone help me please? I've created a pie chart in Numbers but the chart has a border around it which I can't seem to remove for the life of me. In Excel it's easy, you select it click line and choose 'no line' but can't seem to find it on Numbers
Not sure what you mean as Pie Charts wouldn't have any border around them at all. It is only an option for other types of charts. Maybe you just mean the blue box around it showing that it is selected? Just deselect it by clicking elsewhere or Edit, Deselect All.
All of my charts get a black line border around it - I can't remove it... Any insights or wisdom is appreciated. BTW, in the format dialogue box there is no border that I can click on.
@@macmost In the current version of Numbers, this option is grayed out. I've searched everywhere on how to remove the frame around the 2d Pie chart with no luck. Did Apple disable it? I really appreciate it your videos. Clear and concise.
@@macmost hi! Thank you, I’m trying to create a progress pie chart, so from 0 to 100% so the more tasks i complete, the closer to 100% I get, the goal is 49 tasks, 49= 100% at the moment, I’ve done 22 but it’s showing me 31%? It should be 44%, I haven’t been able to edit the Data reference to 49 = 100%, I hope that makes sense ?
Can you create sub categories with each category? (ex. with in the apples category show a break down of sub categories like red apples, green apple) So you can see over the category of apples is 45% and of that 45%, 15% of them were red & 30% were green. sorry example doesn't really align with your demonstration but the category choice is superfluous to the question. thanks in advance.
The simple pie chart at the start doesn't work. When you select all, it gives a pie chart with no pieces. You have to select the right hand column with the numbers only!
Wow that is not intuitive at all! Microsoft really has this market cornered! Say what you will about them but they got the spread sheets and word processing down pat. I'd love to see a column chart for non-sequential rows (A1,B1;A8,B8;A15,B15). That is IMPOSSIBLE to do in Google Sheets (well impossible to label the X access for each date - have to manually label each column by hand).
amazing. this was SO well-explained. I was trying to create a pie chart to help my friend log the intensity of his migraines over time and this help TREMENDOUSLY. potential life-saver. thank you.
You sir, are a genius! We’re always told to RTFM but having someone like you explain clearly makes spending the time watching your vids.so worth it!
Kudos and Happy New Year!
Another highly useful 5 minutes of time. Your tips are tremendous. Thanks
As a typical Excel user at work, I hardly ever use Numbers. That’s gonna change! Great mini tutorial as always.
Thank you for making this so simple! Spent ages trying to find straight forward instructions from apple
Gary you are a good teacher.
very helpful to an old Excel guy, thanks
Excellent - clear, and quickly gets to the point. Thank you.
Thank you for the video! exactly what i needed!
Awesome Gary! Thanks you are saving me a lot of time and struggle.
exactly what I've been looking for! Thanks!
Thanks for the great tutorial!
Much easier than I thought! 😅
this is the most helpful video everrrrrrr! thanks so much
I'm doing a spreadsheet for my finances and I wanted to make charts of the data. I unfortunately have 3 different bank accounts so that's 3 checking and 3 savings. I have 4 401k's I have several IRA's and Roth IRA's so you get the picture. These accounts have their own line on the Numbers spreadsheet and I was hoping to be able to assign a "category" to each item and make a clean chart. For example The Bank of America IRA, The Credit Union IRA could both be put under a "IRA Category" and the same with everything else having their own categories so I can make a graph that shows only the categories and not all the different individual accounts. Thanks again for all your videos I've been watching for over a decade.
Bravo Sir!
This was very helpful, and right to the point. Thank you!
Great Help And Wishing a happy, prosperous 2020
Exactly what I needed! Appreciate it! :)
Excellent. Very informative
Thanks, this was really helpful!
excellent, thanks!!
Thanks! great tips 😃
Hi, I have question. What if a customer orders 2 different pies? As if there are 2 pies in one cell separated by comma, e.g. "Blueberry, Apple" written in cell T1::B2. How to make the program still count that as individual pie instead of combining those value? I came across this problem when I exported data from a survey I made using Google Form.
What was your resolution?
Thank you
The people who made numbers are so freaking incompetent. Why can't they make it plain and simple. Thanks for the video btw
Great tutorial
I've populated my values via links to cells in other worksheets and I just can't seem to get the pie chart to work. It looks just like a two-column table, however the data column refers to the cell in another work sheet. Can anyone help with this?
I can't get the category count function to work, it just counts the number of actual categories, rather than the number of entries within each category, any thoughts? To add, i'm getting the same problem using the countif function
Very helpful
Are you allowed to edit the number of colors used in pie charts, lists, etc? The maximum amount currently appears to be 6 colors allowed. Is there a way to increase that number? Standard colors appear to be "Blue, Green, Grey, Orange, Red and Purple"
You can change any slice to any color you want. You are not limited at all. Select a wedge and use the Style sidebar.
What if you want to make multiple pie charts from different data sets within a single table? I have a table with 11 columns and I need to make pie charts for 6 of them which seems to eliminate the category option. Is my only chose to do counts separately then chart?
You can select a set of cells and do a pie chart on just those cells. So you can make multiple pie charts from the same table, sure. Not sure what you mean by your last sentence.
thank u
❤
Hi Gary, My table has about 5,000 rows that can be separated by 15 categories.Some categories may include over 1,000 rows. When I follow the guide I end up with a concise table with 2 columns: name, sum. When I click on the table to create a pie chart I get the message "A chart can’t have more than 300 series. Try again with fewer selected cells.". Is there a limit to how big your table can be to use the "easy method"?
That makes sense. Think of how small some of the slices would be in a pie chart with hundreds of items in it. Not very useful. So what is it you are trying to do, exactly?
Just use the group totals so end up with 15 slices. I collapse the groups on my table.
@@johnscibal So create another table that has those group totals in 15 rows using SUMIF functions. Or, use a Pivot Table to do it without functions if you prefer.
Can you count something that doesn't fit the exact description? For example every discription that has 'pie' in it: creampie, apple pie --> counted as pie. And everything that has 'book' in the description, for example 'workbook', textbook'... --> counted as book. Or does it has to be the exact description to be counted?
You can add a new column for "type" and put "pie" or "book" in there and use that. You can use functions to test the other column for conditions (whether "pie" or "book" is in the text) to do it automatically if you are good with functions.
Hi! I have a question about my Mac. How can I ask you? Thank you for your videos as I watch them regularly.
macmost.com/ask-a-forum-question
Awesome job! I have a question: When I am doing a normal bar graph where I am comparing two things, such as a goal and actual #s, when I add the actual #, it makes my goal go higher even though I have a set amount in there. Any thoughts?
Not sure what you are describing, sorry. Maybe you are using the wrong type of chart?
Thanks, gary
Anyone know how to do the pie charts on the iPhone??? I’m trying to do a simple budget but have added more categories and would like a pie chart but can’t seem to get it to work
Can you describe what you are trying right now to create a pie chart and where you are running into trouble?
@@macmost hey I’ve managed to get a pie chart but was wondering if there was a way to pick certain colours for each slices of the pie? It’s only using 4/5 colours at the moment and I’d like to break it down further. Thank you for speedy reply, much appreciated
@@wilsonblack2023 Yes, you can change the colors and use more rows to get more slices. Keep exploring it.
thank you for this! My question; what if there are 22 kinds of pie? My text goes right through the pie itself…😢
You have to adjust as needed. Lots of controls for that.
Thank you so much for this tutorial..your explanation is very clear. I have created categories for numerous cities in my database BUT when I click to create a pie chart, I get an error message that a chart can not have more than 300 series. I am trying to show how many occurrences for each city in a particular state. My entire spreadsheet contains around 8,600 rows of data...HELP
I wouldn't make sense to do a pie chart for 8,600 pieces of data. The slices would be too small to be visible.
@@macmost thank you for your quick response...there are numerous cities that are repeated across the 8;600 rows of data, so the “categories” filter counted the number of occurrences for the various cities...now I am trying to get those totaled city “categories” to appear in a pie chart...I just now tried selecting (rather than the entire table) only the cells in the table with the city name and the category total for each city and then selecting a pie chart....that SEEMS to get me closer to what I am looking for than anything else I’ve tried over the last 5 hours...i had been trying to do this in Excel with no success...I knew nothing about the Numbers application on my MAC and did not know it was comparable to Excel I thank you again for your excellent tutorials! I will attack this again tomorrow on a “refreshed brain”
@@Delta1Duck did you ever figure it out? I'm having the same issue
In Excel, we have macros (which opens a programming app called VBA). Does numbers have the same functionality ?
Yes. You can use AppleScript or JavaScript to automate all sorts of things, not just in Numbers but other apps too. In fact I have a video coming out tomorrow that uses JavaScript with Numbers.
I'm getting the category but the count is zero...even though I see data there. What am I doing wrong?
Impossible to guess since I can't see what you have. Look closely and check everything.
Thanks for the vid! Currently having an issue where when I’m using a drop-down menu for the list of choices; you can categorize the column and set the count like in this video and it reflects on the piechart but it doesn’t update new data. The chart only updates the list of options that were already selected in the drop-down menu..so if I have 5 rows, and in the column A for each cell I have a drop-down list of 6 options. Let say I added the column A reference to a chart after setting the category and count feature. If at that moment I had 3 of “Option 1”, 1 of “Option 2” and 1 of “Option 3”, the chart will read 60% Option 1 , 20% Option 2, and 20% Option 3 (which is correct). Now when I update any of my selections in that column, for it to reflect on the chart I can only choose between Option 1-3. I can also add new rows and it will reflect as long as I don’t choose between Option 4-6. Is there an way to have the chart to do a complete refresh of its references every time I update a cell in that column? Or a way to give the chart a preset of data (drop-down list options) rather it only recognizing the selected options of the column cells? Should I be sending this message to Apple tech team?🤔
So you are using Categories, and then you add a new category, and the chart doesn't update. Yes, that's just the way it works now. You need to click Edit Data References under the chart, and then click the cell with the value you want to add to add the new category summary.
@@macmost no, I only set up the Category feature once…In column A, each cell have a pop-up menu (drop-down list) of 6 options. I have only 3 of the options (Options 1-3) chosen in the table. Then I go setup the category and the count feature. It works fine. I then go add the reference of column A to the pie chart. I can add more rows and change the options from the pop-up menu in the individual cells without a problem. The category and count feature updates on the table itself correctly, whether I chose any of options 1-6. However the pie chart only updates if I chose between options 1-3, once I start picking options 4-6 the chart doesn’t update correctly.
@@thewld2 Sorry, I don't know what the problem could be then. I'm able to add more values to column A and use Edit Data References to then add that category value to the chart.
@@macmost ima give an example of a real scenario. Let’s say it’s a budgeting spreadsheet. I have a table of expenses. Column A is the “Name” of the expenses. I have let’s say 3 expenses: Rent, Food, Car Note. Now in Column B I have the “Type” of expenses. So each cell have a pop-up menu of 5 options (Lifestyle, Entertainment, Insurance, Home, and Debt). So for “Rent” -> “Home”, “Food”->”Lifestyle”, “Car Note”->”Debt”. Now I setup the category for Column B and setup count. Home reads 1 count, Lifestyle reads 1 count, Debt reads 1 count. I then go setup the pie chart to reference Column B. The chart will read 33% Home, 33% Lifestyle, 33% Debt. If I change Food->Home, the table will read 2 Home, 1 Debt and the chart reads 67% Home, 33% Debt (which is correct).…now this is when it starts breaking down. If I change any of the 3 expenses to “Insurance” or “Entertainment” the table will update correctly but not the chart. So let’s say, change Food->Insurance, table will read 1 Home, 1 Insurance, 1 Debt, but the chart will read 50% Home, 50% Debt. It’s doing this because when the reference was setup, only “Home”, “Lifestyle”, and “Debt” was selected for the 3 expenses. It never recognized the unselected options “Insurance” and “Entertainment”… I can add more rows (expenses) and as long as for Column B I choose between “Home”, “Lifestyle” and “Debt” the chart will update correctly. But as soon as I choose an option (Insurance, or Entertainment) it hasn’t seen before when the reference was setup, it will break. The table however works fine, with no issue.
@@thewld2 Not sure what to suggest. Maybe use a second table instead of Categories. Have that table do your calculations and also generate the chart from it.
Hello Gary, thank you for this video, right to the point and very helpful. Do you have a sequel to this with sub-categories? thanks in advance.
Creating Pie charts with subcategories? Or something else?
@@macmost Pie charts with subcategories, thank you
@@ma_rio01 So like if you have a 365 days (rows) of data, how can you do a pie chart that shows 12 months?
@@macmost I have a category with years and a subcategory with months, I would like the chart show the months, but if a select the column I only see the years.
@@ma_rio01 So I assume you have the subcategories set to show subtotal, average or something like that, right? Create the pie chart. Click the Add Chart Data button. Then click each of the 12 months' subtotals to add them as 12 wedges on the pie chart.
Ahhh yes thank youuuuu
Awesome videos....
How about a video on searching the contents of an external drive. I have done what is found on the internet. However, none of it works.
You shouldn't have to do anything special to search an external drive. Just a regular search should turn things up. If you want, start at the top level of that drive in the Finder and search from there to narrow the search to that drive. If that doesn't work, then is the drive formatted any way special?
you rule!
This the best
Thank you
Can anyone help me please? I've created a pie chart in Numbers but the chart has a border around it which I can't seem to remove for the life of me. In Excel it's easy, you select it click line and choose 'no line' but can't seem to find it on Numbers
Not sure what you mean as Pie Charts wouldn't have any border around them at all. It is only an option for other types of charts. Maybe you just mean the blue box around it showing that it is selected? Just deselect it by clicking elsewhere or Edit, Deselect All.
All of my charts get a black line border around it - I can't remove it... Any insights or wisdom is appreciated. BTW, in the format dialogue box there is no border that I can click on.
In Format, Chart, under Chart Options there is a Border checkbox.
@@macmost In the current version of Numbers, this option is grayed out. I've searched everywhere on how to remove the frame around the 2d Pie chart with no luck. Did Apple disable it? I really appreciate it your videos. Clear and concise.
@@DanielAmbroseStudio Not sure why that option is grayed out for you. Try it with another chart maybe? Definitely works for me.
@@macmost Hmm.... I'll keep trying. I appreciate your prompt response.
The official apple documentation doesn't even discuss this
Where did the numbers come from?
How can I create a progress pic chart using Numbers! I'm stuck!!
You'll have to explain a bit more. What are you trying to create, exactly? Maybe ask at my site (macmost.com) where you can explain in more detail.
@@macmost hi! Thank you, I’m trying to create a progress pie chart, so from 0 to 100% so the more tasks i complete, the closer to 100% I get, the goal is 49 tasks, 49= 100% at the moment, I’ve done 22 but it’s showing me 31%? It should be 44%, I haven’t been able to edit the Data reference to 49 = 100%, I hope that makes sense ?
@@22Danmilo Hard to say what you could be doing wrong without seeing your whole table.
Can you create sub categories with each category?
(ex. with in the apples category show a break down of sub categories like red apples, green apple)
So you can see over the category of apples is 45% and of that 45%, 15% of them were red & 30% were green.
sorry example doesn't really align with your demonstration but the category choice is superfluous to the question.
thanks in advance.
Yes, you can add more than one category. Try it.
The simple pie chart at the start doesn't work. When you select all, it gives a pie chart with no pieces. You have to select the right hand column with the numbers only!
Wow that is not intuitive at all! Microsoft really has this market cornered! Say what you will about them but they got the spread sheets and word processing down pat. I'd love to see a column chart for non-sequential rows (A1,B1;A8,B8;A15,B15). That is IMPOSSIBLE to do in Google Sheets (well impossible to label the X access for each date - have to manually label each column by hand).
doesnt work at all
mmmmm pie