I have a line chart in Excel 2007 that is created from data in the worksheet. It has several series whose titles are displayed in the chart on the right side. The names of the series are of the form XXXyyy
, where yyy
should be rendered in superscript.
How do I achieve this superscript display of the series titles on the chart?
Best Answer
I have 2 ways:
1. If you are using only the "1", "2" and "3" digits in superscript, you can change them to these characters:
character ³: in your keyboard: alt+0179 / US-International Keyboard: altgr+3
1.1. Note: In alt+#### and similar combos, you have to hold alt and then hit the digits from numpad number keys (not the ones above letters), i.e., alt+0185 = hold alt, press numpad 0, press numpad 1, press numpad 8, press numpad 5, release alt
1.2. Note: I'm not sure about the name of "US-International Keyboard", but in a lot of keyboards I used (one had a similar name) that combos (altgr+1, 2 or 3) worked.
2. You can use another character font. Some fonts are designed for math, so:
2.1. Install one of these fonts:
2.2. Open your excel file, select cells containing legend text and change font to one of these
2.3. Use Windows Charmap (Start > Run > Charmap) or Office Insert > Symbol menu to copy and paste or insert superscript (or subscript) characters you want on the contentes of these cells
2.4. Double click on graph, select the legend and change font to the chosen one
2.5. See an example in my Google Docs using DejaVu Sans: http://goo.gl/VZL0D
HOT TRICK!!!!!!!
If can only copy-paste following characters (including letters) in superscript and subscript. Do it in your Excel file. Remember to use Unicode fonts (you can use mentioned fonts above / this text was copied from Wikipedia and Chris Morgan's answer on a StackOverflow question and edited):