Excel Graph - Subscript/Superscript in legend

Question

I have a graph (chemistry) that shows data of chemicals where the chemical names have subscripts (e.g. CO2). The legend for each curve refers to a cell's value. In the cell, the number 2 is clearly set as subscript and displayed as such but the legend in the graph is drawn without the subscript formating.

How can I set the legend to match the use of subscript/superscript of the cell it is supposed to use for its text?

Note: I'm not interested in adding text boxes or other hacks because I'd have to manually update them if I change the content of the cell and they would not work well when the graph is copied and pasted into Word.

Answer 1

Don't use subscript/superscript - it won't work as you have found.

Use subscripted/superscripted characters instead:

Answer 2

Hi.

Thanks for that. That will work for numbers.

Now, what if the character that needs to be superscripted/subscripted is a letter (Roman alphabet or Greek alphabet)?

D.

Answer 3

See https://en.wikipedia.org/wiki/Unicode_subscripts_and_superscripts

Answer 4

The Royal Society of Chemistry used to supply an excellent font (ROYASCN.TTF) which has all letters sub/super-scripted and works great. Couldn't see it on their website today though !

Answer 5

See https://edu.rsc.org/resources/rsc-chemistry-font/4013014.article