Skip navigation

Consolidating charts

3386 Views 28 Replies Latest reply: Dec 12, 2012 12:59 PM by Niku RSS
1 2 Previous Next
Niku Level 2 Level 2 (285 points)
Currently Being Moderated
Dec 8, 2012 11:23 AM

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 Level 6 (12,625 points)
    Currently Being Moderated
    Dec 8, 2012 12:26 PM (in response to Niku)

    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:

    http://support.apple.com/manuals/#productivitysoftware

     

     

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

  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Dec 8, 2012 3:19 PM (in response to Niku)

    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.

     

    Before:

    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

  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Dec 8, 2012 6:27 PM (in response to Niku)

    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.

  • Wayne Contello Level 6 Level 6 (12,625 points)
    Currently Being Moderated
    Dec 8, 2012 8:03 PM (in response to Niku)

    Niku,

     

    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.

  • Badunit Level 6 Level 6 (10,760 points)
    Currently Being Moderated
    Dec 8, 2012 9:25 PM (in response to Niku)

    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.

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.