Ask Your Question
2

X Axis label text direction

asked 2016-08-29 22:05:46 +0100

Paul Grime gravatar image

updated 2016-09-04 21:05:54 +0100

mark_t gravatar image

LibreOffice Calc 5.2.0.4.

I have a bar chart with three labels on my X Axis. I am am trying to set them all to 45 degrees text direction, but only the first label uses the text direction. The other labels remain horizontal.

How can I make all X Axis labels use the same (or individually set) text directions.

I have an image to upload to demonstrate this, but I don't have enough 'karma'.

Edited by @mark_t to include details added as answer by @Paul Grime.

image description

Axis now renders as the following, with only one of the category text at 45 degrees. I.e. "i7" and "Atm" are at 45 degrees, "0" and "2G" are not.

image description


Edit - Using CHAR(10) to combine multiple columns into one 'display' column, and using rotation on that single label. I would like each individual category label to have the same x coordinate, and be vertically stacked using the same x coordinate, but combining the labels means they advance too far to the right and cause LibreOffice to drop the next column label (as it can't fit it in, I guess).

This is what I get: image description This is what I want: image description

Thanks.

edit retag flag offensive close merge delete

Comments

Edit your question and attach example as spreadsheet document after removing any confidential info.

mark_t gravatar imagemark_t ( 2016-08-30 00:40:57 +0100 )edit

Sorry, but I can't find any part of the UI that allows me to edit my question. Any ideas how? Do I need more 'karma' for that? I use Stack Overflow and can edit my questions on that platform.

Paul Grime gravatar imagePaul Grime ( 2016-08-31 00:45:52 +0100 )edit

I think you should be able to edit your question, should be an edit option just to the right of the Comments title below your question.

mark_t gravatar imagemark_t ( 2016-08-31 01:18:50 +0100 )edit

I see "flag offensive", "close" and "delete"

Paul Grime gravatar imagePaul Grime ( 2016-08-31 01:38:35 +0100 )edit

Try add it in an answer to your own question and I can try and tidy it up.

mark_t gravatar imagemark_t ( 2016-08-31 01:50:21 +0100 )edit

Will do, thanks.

Paul Grime gravatar imagePaul Grime ( 2016-08-31 18:38:34 +0100 )edit

I moved the additional info from your own answer to your question in the hope that others might understand what you are trying to achieve. I don't have enough karma to actually delete that answer.

mark_t gravatar imagemark_t ( 2016-09-04 21:17:43 +0100 )edit

Thanks @mark_t. I'll delete my non-answer as you have moved its info into the original question.

Paul Grime gravatar imagePaul Grime ( 2016-09-04 22:30:56 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2016-09-01 16:28:12 +0100

mark_t gravatar image

updated 2016-09-04 21:19:00 +0100

Edited 4th Sep 2016, to remove suggestion to select secondary x axis.

Edit, I was able to duplicate the issue by using two columns of data as category label. I guess from your example you are using three columns. It seems the rotation is only applied to the data from the first column and the second two are not rotated.

I found its possible to work around this by including a helper column, where the two or three columns can be combined into a single column for the category label. If you want to keep the columns on separate lines in the label you can use the CHAR function to include a new line.

=A3 & CHAR(10) &B3

Attached very simple example to demonstrate.

Untitled 17.ods

Edited 4th Sep 2016. I think the only method to achieve what Paul Grimes is looking for would be to add text boxes for the two additional category labels and use only a single column for the first category label of each bar in the chart.

edit flag offensive delete link more

Comments

Thanks, but that doesn't seem to work. I'm not sure I have multiple 'real' X axes, I have categories that are displayed with/beneath the 'real' X Axis label ('real' X axis labels are "i7", "Atm", etc and categories are "0", "2G", etc, in the smaller image).

Paul Grime gravatar imagePaul Grime ( 2016-09-02 12:04:39 +0100 )edit

Thanks again. It's a great answer and I appreciate your help. Unfortunately, the way the rotation is now rendered means it drops labels when it can't fit them in. I've provided an image to demonstrate.

Paul Grime gravatar imagePaul Grime ( 2016-09-03 18:35:00 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-08-29 22:05:46 +0100

Seen: 2,133 times

Last updated: Sep 04 '16