Dear All,
After creating a graph, when we make the legends appear, is automatically generated based on the name for the particular data. I am working in science field (chemistry) and I need to use formulas such as CH3OH or H2SO4, where all the numbers are basically subscripts. However, since it is not possible to use such subscript or super-scripts in naming the Title of the data, in the legends as well I get this chemically wrong information. I typically end up using TEXT but then auto-generated line shape and colors are slightly different than on the graph. The best way is to have it automatically generated, correct formula as well.
Is there a simpler and smarter way to deal with this problem???
Thank you all
PS
Superscript letters or numbers appear slightly above normal text in smaller font. Superscript is commonly used when writing mathematical expressions or formulas or in chemistry when identifying isotopes or chemicals and compounds. Although there are no designated superscript or subscript keys on the keyboard, you can use keyboard shortcuts to write them. When creating a spreadsheet in Microsoft Excel, you can use the available superscript button or keyboard shortcuts to write in superscript.
Word for Office 365 for Mac Word 2019 for Mac Word 2016 for Mac OneNote for Mac More. Less A superscript or subscript is a number, figure, symbol, or indicator that is smaller than the normal line of type and is set slightly above it (superscript) or below it (subscript).
Step 1
Select the cell or highlight the text you want to designate as superscript.
Step 2
Click the 'Home' tab, and select the 'Format Cell Font' button located next to the 'Font' title.
Step 3
Click 'Effects,' and check the box next to 'Superscript.'
Press 'Ctrl' + 'Shift' + 'F' or 'Ctrl' + 1' to bring up the font tab automatically instead of clicking through to reach it.
Video of the Day
Brought to you by Techwalla