Previous 1 2 Next 28 Replies Latest reply: Dec 12, 2012 12:59 PM by Niku
Niku Level 2 (285 points)

I've just started using Numbers today, so I have  lot to learn. On the other hand, the project I'm now working on now is very simple, so i'm hoping that it will be  extremely easy to do. I'll tell you what I want to do, and I'd like to be told if it can be done before I start looking through the manuals and videos. I want to prepare a chart with 223 rows and 20 columns. The vertical column to the left would have the names of 223 singers, and the columns to the right would be headed by the years from 1920 to 1939. I now have all of the singer's names, but because the templates I'm using have only 45 rows, I've had to prepare five charts.


Is there a way to combine my five charts into one? Is it then a simple matter to forward the consolidated chart as an E-mail attachment?  Finally, if you have any thoughts as to a good place to look for such information, i'd like to hear about it.

iDVD 7.1.1 (1150)
  • Wayne Contello Level 6 (16,935 points)

    I think you should be able to store all the data in a single table, then plot in a single chart.  Do you have an example you use to post a screenshot?


    to email a pdf from any application on the Mac OS, use the menu item "File > Print", then clickand hold the pdf button.  then you can select "Mail PDF":

    Screen Shot 2012-12-08 at 2.22.43 PM.png



    Numbers users guide is pretty good and is a free download here:



    It is always worth your time to look at the doc in addition to using the resources on this forum.

  • Niku Level 2 (285 points)

    Well, there are manuals, to be sure, but I don't like using manuals on the screen, and I'm not ready to print the 225 pages that one manual contains. I thought it would be easier to get started in the right direction. If you had said, for example, that it is impossible to prepare a chart with 200+ rows, I would have just had to accept that and work with what is possible. However, you say that it is possible, so now I know that I won't be wasting my time by looking for something that doesn't exist. As to sending a screenshot, I'll try, but it seems to me that I have never been able to post something like that here. Here goes.

  • Niku Level 2 (285 points)

    Well, at least I did better than I have in the past. This chart has all the names, but it's missing the numbers 1 through 45 to the left of the names, and it's missing the years at the top of the columns. I might add that I keep misplacing the years. Sometimes they're there, and sometimes not. . 

    Mack, Mirth













    MacDonald, Jeanette













    Marcotte, Ruth Marie













    Maddux, Frances


























    Mann, Mabel













    Marks, Mabel













    Matthews, Ester













    Maughan, Dora













    Maurice, Vivian & Cecil













    McCoy, Viola













    McPherson, Ozie













    Melville, Winnie













    Merle Twins













    Miller, Beth













    Miss Dalley













    Miss Mitzi













    Mitchell, Nita













    Moncrieff, Gladys













    Moore, Grace













    Morley, Alice













    Morgan, Helen













    Morse, Lee













    Morten, Lillian













    Nordstrom, Sisters













    Novak Girls













    O’Connor, Kitty













    Oldham, Florence













    O’Neal, Zelma













    Painter, Eleanor













    Parkes, Ennis













    Paull Sisters













    Payne, Greta













    Penn, Ann













    Petrie, Cecile













    Pickens Sisters













    Ponce Sisters













    Ponder, Suzanne













    Preer, Evelyn













    Pursell, Jane













    Quine, Grace













    Raymund, Helen













    Rice, Glsdys













    Richards, Helen













    Robins, Phyllis













  • Niku Level 2 (285 points)

    Maybe "Numbers" is not what I should using. I started with "Page,"  but it seemed to me that "Numbers" would be better for my job. Now a friend is telling me that I should use "Database". Isn't "Numbers" a "Database"?

  • Badunit Level 6 (11,515 points)

    First, I assume you meant to say "tables, not "charts".  Tables have columns and rows. Charts are graphical plots.


    Second, you can add rows to tables. You aren't stuck with the default of the template. You could have made a single table instead of five.


    Third, you can easily combine tables. In the example below, I have two tables that have the same headers. I want to combine them. 

    1. Select the second table.
    2. Select rows 2-4 of that table by clicking on the row number "2" then shift-clicking on the row number "4".  You should get a selection box that surrounds all of those three rows
    3. Click and hold on one of those row numbers and drag to the right to "lift" the rows from the table
    4. While still holding the mouse button, move your cursor to the bottom of the first table. A blue line will appear. This is where the rows will be placed.
    5. Let go of the mouse button.
    6. Delete what remains of table 2.  In this case, because we moved all but the header row, the entire table 2 is still there for you to delete. If we had left a row in the table, the moved rows would have been deleted automatically.



    Screen Shot 2012-12-08 at 6.10.18 PM.png


    After (but before deleting table 2):

    Screen Shot 2012-12-08 at 6.11.04 PM.png

  • Niku Level 2 (285 points)

    That's the kind of advice I needed, alhough it would have been more helpful if you had said how to add a row. No matter, I discovered how, and I'm now on my way to 223 rows click-by-click. However, it occurs to me that there might be a faster way to add many rows. What does that symbol that looks like a wishbone mean? It's right in front of a down arrow, and I assume that by clicking on the arrow at the same time as some other key, the progress would be continuous.


    I can no longer combine the five tables I had already made, because I somehow lost all of the content of one of them when I was trying to do something with it. I did find it once, but then I lost it again and was unable to recover it again. Well, I'm now going back to add a hundred or so more rows.

  • Niku Level 2 (285 points)

    Well, I guess there are no shortcuts. I just lost that 223-row table I had spent so much time creating, and I don't know how to get it back. There are just too many ways to go wrong. I'm quitting for the day (this is tiring work), but I'll be back tomorrow to watch tutorial videos and to copy appropriate pages from the manual. Exchanging messages at this level is just not helpful. I'm closing this case for now. Perhaps after I learn more, I'll be back.

  • Badunit Level 6 (11,515 points)

    I have no idea what you did to delete your table, if you did, in fact delete it.  It is possible you slid it far out of sight or underneath another table but it is still there somewhere. The sidebar on the left has a list of all your tables. If it is still on the list, it is still there somewhere.


    If the table has been deleted but the document is still open, try Edit/Undo a few times and maybe your table will reappear. Otherwise, go to the menu under File/Revert To and you can revert to a previous version of your file and maybe that will get your table back.


    I'm at a loss as to what the "symbol that looks like a wishbone...right in front of a down arrow" is. I don't see anything like that.


    Reading through the user's manual will definitely teach you faster than clicking things randomly.

  • Niku Level 2 (285 points)

    Badunit wrote:



    Reading through the user's manual will definitely teach you faster than clicking things randomly.

    I finally reachd that conclusion after my growing list of questions made me call a halt to my flailing around. Why do my tables keep disappearing? Why do the numbers in the leftmost column disappear? Why did all of my column titles disappear? Why do my tables keep being broken up? Why do my sheet  names disappear, and where do they go? Why did my sheet name relocate itself to the 173rd row from where it can't be removed? On and on. More and more problems that needed answers. Finally, I realized that I was just getting in deeper and deeper with no relief in sight. ENOUGH!

  • Wayne Contello Level 6 (16,935 points)



    Numbers is not MS Excel.  The row/column headers disappear when you deselect a table-- as they are only necessary when you are editing a table.

  • Niku Level 2 (285 points)

    Wayne Contello wrote:




    Numbers is not MS Excel.  The row/column headers disappear when you deselect a table-- as they are only necessary when you are editing a table.

    I'm not sure that I understand. I need those headings; they form an integral part of the table. The table would have very limited--no, it would be worthless--if the years at the top were to be deleted.

  • Badunit Level 6 (11,515 points)

    Wayne was talking abut the column letters and row numbers. If you look at my second screenshot, the bottom table (which is selected) is showing the column letters and row numbers while the top table (which is not selected) is not. Both tables have a header row that has the dates in it and both have a header column that has the names in it. The headers and all the data are displayed regardless of whether the table is selected or not.

  • Niku Level 2 (285 points)

    I decided to try something simple this morning before sitting down with the manual: I moved the Years-row down one notch, so that it is now below the template horizontal letters. Here's the result:


    Unfortunately, I'm only allowed to be successful in short spurts, and when I started losing things again, I decided to be content with this one victory and hit the books.

  • Niku Level 2 (285 points)

    Okay, Badunit, I now know enough now to publish my first chart and send it to my Yahoo group. I've prepared the table the way I want it, and now I just have type in the two hundred twenty-three singer names and the number of recordings each singer made in a particular year, and that'll be it. Just some typing, and no more mysterious losses. My next project will be to type the names of approximately two hundred songs and the names of all of the singers who sang those songs in the period from 1920 to 1934, This will range from one to, say, eighteen. I want the easiest way to do this. Would it be possible to have two parallel lists (singers and songs) so that I could just drag the singers to the appropriate song? Or, maybe there's a better way. While I'm waiting, I'll finish with the first project.

Previous 1 2 Next