Excel chart subscript, superscript

Question

Hello, 

I have noticed that when creating a new chart in Excel, it is impossible to add subscript and/or in superscript in the axis' name. Can you please let me know if it is possible and how to do it?

Thank you in advance

Best wishes, 

Ewa

Answer 1

Hi Ewa,

Thanks for posting in the community, I’m glad to offer help.

According to your description, we indeed can’t add subscript or superscript in the axis’ name by a conventional way.

However, we use the corresponding Unicode characters to instead of applying font format, here are some common subscript/superscript Unicode characters that you can copy to use in your data directly: ⁰¹²³⁴⁵⁶⁷⁸⁹₀₁₂₃₄₅₆₇₈₉

For more Unicode characters, you can refer to Unicode Character Table (starting from U+2070)

 

Meanwhile, you can post an idea in UserVoice, it is the best way to let the related hear your needs, anyone’s suggestion could have a chance to be adopted by Microsoft.

Hope the above information can help you, please feel free to post back if it works for you or you have other concerns.

Best Regards,

Arck

Answer 2

Hi Ewa,

Have you tried to search for the letter through the above website? For example, you can enter the keyword “superscript a” to get the corresponding Unicode letter. However, it doesn’t seem to list all 26 letters.

Since it is just a workaround, if you want there is such a feature that works perfectly in Excel in the future, I suggest you try to post this idea in UserVoice as I mentioned before.

Best Regards,

Arck

Answer 3

Hi Ewa,

I just tried Arck Tang's suggestion and it works perfectly - but the Month column must be formatted as Text in order for this trick to work.

To format the column (in this case Column A) as text, click on the letter A at the top of the column and press Command-1. In the dialog, look for Text in the list of formatting options and then click the OK button.

If you plan to use the months as dates in calculations or for automatic displays such as conditional formatting, pivottables, slicers, etc where you want Excel to know the date value, you'll need to add an additional column foratted as Date. You can always hide the extra column, but you may need to use the date values instead of text for certain features.

Answer 4

Hi Ewa,

I’m writing this reply to follow up the case, may I know whether you have checked the above replies? When you get time, please post back to let us know if you still need help here.

Hope you are all well during this period, stay safe and take care.

Best Regards,

Arck

Answer 5

Hi! Thank you for your response. It works, but still it is impossible to do letters in subscript and superscript. Do you have any idea for that?