X Axis label text direction

[PaulGrime]

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.

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.

---

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:

This is what I want:

Thanks.

[mark_t]

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

[PaulGrime]

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.

[mark_t]

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.

[PaulGrime]

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

[mark_t]

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

[PaulGrime]

Will do, thanks.

[mark_t]

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.

[PaulGrime]

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

[mark_t]

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.

[PaulGrime]

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

[PaulGrime]

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.