+ Reply to Thread
Results 1 to 9 of 9

Rotating multiline graphic label

  1. #1
    Registered User
    Join Date
    03-14-2019
    Location
    Patagual, Chile
    MS-Off Ver
    Office 16
    Posts
    14

    Rotating multiline graphic label

    I am trying to rotate all texts at 270 degrees. My label has got 2 words, strange enough the first part rotates but not the second part. Any idea why ?

    picLabel.jpg
    Last edited by Corobori; 03-15-2019 at 05:10 PM.

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Rotating multiline graphic label

    It's concatenating two columns or something, right? I think you'll need to rotate both columns separately.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    03-14-2019
    Location
    Patagual, Chile
    MS-Off Ver
    Office 16
    Posts
    14

    Re: Rotating multiline graphic label

    How do you do that ? I have rotated using the Format Axis > Text Options > Text Direction

    picLabel2.jpg

  4. #4
    Registered User
    Join Date
    03-14-2019
    Location
    Patagual, Chile
    MS-Off Ver
    Office 16
    Posts
    14

    Re: Rotating multiline graphic label

    Anybody with a clue ? As I am new on that forum it seems I am not allowed to post a link so you didn't hear from me that in the root of my website corobori.com a sample called Sample.xlsx was uploaded

    picLabel3.jpg
    Last edited by Corobori; 03-15-2019 at 03:36 PM.

  5. #5
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Rotating multiline graphic label

    Right click the axis, choose Format Axis, and in the Labels section, uncheck "Multi-level Category Labels". That will rotate both numbers. However, it will put the week number "above" the year.

  6. #6
    Registered User
    Join Date
    03-14-2019
    Location
    Patagual, Chile
    MS-Off Ver
    Office 16
    Posts
    14

    Re: Rotating multiline graphic label

    Melvosh You're right but it doesn't help on my real live sample. The print screen, see below, has got one sample with the "Multi-level Category Labels" option marked and on one with that option not marked. None of them looks good.

    Thanks for the suggestion

    piclabel4.jpg

  7. #7
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Rotating multiline graphic label

    You could add a column to use as your axis labels that uses this formula:
    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    03-14-2019
    Location
    Patagual, Chile
    MS-Off Ver
    Office 16
    Posts
    14

    Re: Rotating multiline graphic label

    Quote Originally Posted by Melvosh View Post
    You could add a column to use as your axis labels that uses this formula:
    Please Login or Register  to view this content.
    It indeed does the job, thank you Melvosh.

  9. #9
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: Rotating multiline graphic label

    Happy to help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot Chart not displaying data label values for the first Legend label
    By zykkzxxy789077 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-24-2016, 05:46 AM
  2. Follow hyperlink stored in label controltiptext when clicking on userform label
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2015, 08:24 AM
  3. Change userform label height without changing label width
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-16-2015, 01:08 PM
  4. MultiLine TextBox line count to display in label or textbox
    By khhoa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-10-2015, 06:02 PM
  5. With a move label macro, prevent label from moving onto another label
    By SocratesJC in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-09-2014, 12:34 AM
  6. Replies: 1
    Last Post: 09-30-2013, 09:52 AM
  7. Extend Label in a Graphic
    By gexxy in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 08-06-2013, 06:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1