Ask Your Question

LibreOffice spreadsheet - subscript/superscript a character in XY scatter graph axes titles

asked 2016-06-17 15:29:18 +0100

UrovorosOfis gravatar image

Dear all,

I have been using LibreOffice (now I have v. for a couple of months and I'm very happy with the software. I'm especially very pleased with the suite's integration with Mendeley.

Regarding LibreOffice Spreadsheet, I'm able to subscript or superscript a highlighted character, when the latter is typed in a spreadsheet cell, by implementing

(right mouse click)->Character...->Position

However, I can't seem to do the same when the character is typed in X and/or Y axis in a XY scatter graph. This applies for both the previous (v5.1.2) and the current version (v5.1.3.2) of the suite.

Please fix it, because I need my graphs to be properly formatted for professional presentations.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-06-17 23:36:11 +0100

m.a.riosv gravatar image

An alternative way is using Menu/Insert/Special Character to insert directly those characters from the font without use character formatting.

edit flag offensive delete link more


Thanks for your reply, it really works. In the future, however, the currently applicable, character formatting function for the spreadsheet area, should be made available for XY scatter axes as well.

UrovorosOfis gravatar imageUrovorosOfis ( 2016-06-18 06:47:40 +0100 )edit

There is a bug report about this matter:
If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2016-06-18 14:10:05 +0100 )edit

answered 2016-07-07 14:06:38 +0100

UrovorosOfis gravatar image

updated 2016-07-07 16:55:37 +0100

In the link provided by m.a.riosv (, comment 4 gives a solution to the problem, so in what follows, I'm drafting an extension of that comment (LibreOffice 5.1.4 was used).

  1. Write the axis title in a spreadsheet cell.

  2. With the cursor bleeping inside the cell, Ctrl+A the cell content.

  3. Ctrl+C the cell content.

  4. Ctrl+V the cell content within the activated (with a double left mouse click) graph area.

  5. In contrast to any character within the default axis titles, any character in the new (or copied) axis titles can be formatted (subscript/superscript) with the "Character..." function (right mouse click).

  6. Delete the default axis titles and use the formatted ones instead. The new axis titles can also be formatted in terms of font type and size, through the "Character..." function (right mouse click).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-06-17 15:29:18 +0100

Seen: 1,039 times

Last updated: Jul 07 '16