5 Replies Latest reply: Nov 19, 2012 12:17 PM by Sean Chandler
Sean Chandler Level 1 Level 1 (5 points)

Screen shot 2012-11-19 at 11.44.34 AM.png

I am creating a timeline for a web development project in numbers

 

I have changed the content scale to get it to fit on two pages (it's illegible on one page) but the tasks are overlaid on the grey column containing row labels

 

How can I make the row labels appear on the right side instead of the left side?


MacBook Pro (15-inch Early 2011), Mac OS X (10.6.8)
  • 1. Re: How can I make row labels appear on the right
    Badunit Level 6 Level 6 (10,815 points)

    Here is what I would recommend:

     

    1. On the menu, under Table, turn off "Repeat Header Columns on Each Page". This will get rid of the left-side header on the second page.
    2. Add a new column to the right side of the table.  Format it so it looks like the header column (your "labels").
    3. In that new column use the formula =IF(A="","",A) in every cell of the column except the header row so it gets an exact copy of what is in your header column (and does not put a zero if there is nothing in a particular row of column A)
  • 2. Re: How can I make row labels appear on the right
    Sean Chandler Level 1 Level 1 (5 points)

    Thanks Badunit - that was a big help

     

    The counterintuitive part of this whole exercise is that to get the timeline printed as I want, I've got to leave the column representing Week 8 blank

     

    Print View:

    Screen shot 2012-11-19 at 2.53.31 PM.png

     

    Normal View:

    Screen shot 2012-11-19 at 2.53.54 PM.png

     

    Numbers has got Excel beat in so many ways, but there are some baffling bits to it!

  • 3. Re: How can I make row labels appear on the right
    Badunit Level 6 Level 6 (10,815 points)

    I cannot enlarge your most recent images.  Maybe the forum is having a problem.

     

    Why do you need to leave week 8 blank?  What I saw in the image in your first post was that the table on page one didn't take up the full width of the page; it didn't go all the way to the rightmost margin which caused your shapes to go over some clear space.

  • 4. Re: How can I make row labels appear on the right
    Sean Chandler Level 1 Level 1 (5 points)

    Leaving week 8 blank is the only way I could get the timeline to break properly over two pages

     

    What I see in normal view and what I see in Print View are so different

     

    I removed the blank column, which has made matters even worse:

     

    Normal view:

    Screen shot 2012-11-19 at 3.40.37 PM.png

    Print View:

     

    Screen shot 2012-11-19 at 3.40.45 PM.png

  • 5. Re: How can I make row labels appear on the right
    Sean Chandler Level 1 Level 1 (5 points)

    I think I am approaching this in the wrong way

     

    1. Trying to make it look too nice (using shapes instead of simple cell colour fills to mark time)

     

    2. Working in normal view instead of print view

     

    I've changed the apprach and it's looking better, if not as pretty