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
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.
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.
How do you do that ? I have rotated using the Format Axis > Text Options > Text Direction
picLabel2.jpg
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.
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.
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
You could add a column to use as your axis labels that uses this formula:
Please Login or Register to view this content.
Happy to help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks