X Axis label text direction

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 @PaulGrime.

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 your question and attach example as spreadsheet document after removing any confidential info.

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.

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.

I see “flag offensive”, “close” and “delete”

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

Will do, thanks.

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.

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

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.

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).

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.