Skip navigation

Line Break in Chart Title??

1679 Views 11 Replies Latest reply: Mar 21, 2013 8:30 PM by kitschpatrol RSS
sunshine21 Calculating status...
Currently Being Moderated
Apr 10, 2011 7:52 PM
Hi! Does anyone know how to make a line break in the title of a chart? For some reason, just pressing return or any combination of return with option, control, shift, etc. does not seem to be working... the title is really long to be on a single line and I'm not able to change the size either.
MacBook Pro, Mac OS X (10.6.6)
  • Thomas Wright1 Calculating status...
    Currently Being Moderated
    Apr 10, 2011 9:44 PM (in response to sunshine21)
    If there is a way to make a multi-line title I haven't found it. The only way I have found to change the size of the title box is to change the title text content or the font and/or type size. The title box expands or contracts to accommodate the size of its contents.
    20-inch mid-2007 iMac / White MacBook, Mac OS X (10.6.7)
  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Apr 11, 2011 4:59 AM (in response to sunshine21)
    Sunshine,

    I suggest that you deselect the Show Title checkbox in the Table Inspector, Table tab. Then Insert a Text Box and format it as you wish the title to be.

    Jerry
    Al iMac and MBP, Mac OS X (10.6.7)
  • Level 8 Level 8 (41,760 points)
    Currently Being Moderated
    Apr 11, 2011 8:06 AM (in response to sunshine21)
    sunshine21 wrote:
    Hi! Does anyone know how to make a line break in the title of a chart? For some reason, just pressing return or any combination of return with option, control, shift, etc. does not seem to be working... the title is really long to be on a single line and I'm not able to change the size either.


    Changing the font or the size is really easy.
    Click the displayed title.
    You will see a text box with two circular handles.
    After that you may define the font name, the size and different attributes like color, underlining…



    Yvan KOENIG (VALLAURIS, France) lundi 11 avril 2011 17:05:52
    To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.6.7)
  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Apr 11, 2011 9:03 AM (in response to sunshine21)
    I believe it ignores carriage returns and the like because the chart title also appears in the sidebar. This is also a good reason to not use long titles for the charts. I would do as Jerry suggested: put the title in a text box (and keep "Chart 1", or whatever, as the official title).
    Mac Pro 2008/Intel iMac 2009/Macbook Pro, Mac OS X (10.6.6)
  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Apr 13, 2011 11:04 PM (in response to sunshine21)
    sunshine21 wrote:
    Kind of a pain so hopefully Apple will fix this in the next version! Thanks again!


    'Hopefully' you will Provide Numbers Feedback and request this feature. You'll find the Provide umbers Feedback link in the Application menu ("Numbers" menu).

    Regards,
    Barry
  • kitschpatrol Calculating status...
    Currently Being Moderated
    Mar 21, 2013 12:26 PM (in response to sunshine21)

    In case anyone is still struggling with this, you can insert line braks in chart column titles by pressing Option-Return.

  • Badunit Level 6 Level 6 (10,765 points)
    Currently Being Moderated
    Mar 21, 2013 6:17 PM (in response to kitschpatrol)

    kitschpatrol wrote:

     

    In case anyone is still struggling with this, you can insert line braks in chart column titles by pressing Option-Return.

    Are you sure?  I think your might be talking about tables, not charts.

  • Jerrold Green1 Level 7 Level 7 (28,215 points)
    Currently Being Moderated
    Mar 21, 2013 7:06 PM (in response to Badunit)

    Badunit,

     

    I think he may be referring to Category Titles, not Chart Names, when he says Option-Return works. Whether he knows it or not.

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Mar 21, 2013 8:29 PM (in response to kitschpatrol)

    Hi kp,

     

    True for Category titles, which are taken from a header column (see examples— Cat 1 through Cat 4 on table and chart below), but not for the Chart title, which displays an option return as a space, and whose box extends horizontally to accommodate the whole title in a single line, even when that line extends beyond the screen/page boundary (see example on chart).

     

    Table names, when shown, are carried in a box that expands only to the width of the table to which they belong, which led to the example above the chart:

    Picture 9.png

    For the table example, there are two tables,

     

    "Table with...title" contains two columns, and is placed behind "Table 1", the table containing the data. Only the first table has the Show title box checked.

     

    Just a parlour trick, though—no advantage I can see to using this method of displaying a long table name over using a  text box, as suggested earlier by Jerry.

     

    I can see where your suggestion regarding category names could have some merit, though. Its disadvantage is in doubling the height of the rows from which those names are grabbed.

     

    Regards,

    Barry

  • kitschpatrol Level 1 Level 1 (0 points)
    Currently Being Moderated
    Mar 21, 2013 8:30 PM (in response to Barry)

    Yeah my apologies, I jumped the gun. The option-return approach only applies to category titles.

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.