Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
I could not find a way to do this, I don't think is possible... I'm waiting for an answer too :) – Nicu Zecheru Jul 7 '11 at 10:50
hey man, all solved! unicode has support to super and subscripts "for cut-and-pasting purposes" with some limitations. so copy and paste :) – kokbira Jul 11 '11 at 19:00
Kokbira: Thanks, accepted as answer :-) – Ashwin Nanjappa Jul 12 '11 at 6:52
up vote 8 down vote accepted

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+0185 / US-International Keyboard: altgr+1
  • character ²: in your keyboard: alt+0178 / US-International Keyboard: altgr+2
  • 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:

  • DejaVu (and its variants - Sans: normal, condensed, light, mono / Serif: normal, condensed): I think it is the more known of my list
  • Cambria Math
  • Candara
  • Consolas
  • Constantia
  • Corbel
  • Lucida Sans Unicode
  • Segoe UI

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:

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):

Consolidated for cut-and-pasting purposes, the Unicode standard defines complete sub- and super-scripts for:

  • numbers and common mathematical symbols ( ⁰ ¹ ² ³ ⁴ ⁵ ⁶ ⁷ ⁸ ⁹ ⁺ ⁻ ⁼ ⁽ ⁾ ₀ ₁ ₂ ₃ ₄ ₅ ₆ ₇ ₈ ₉ ₊ ₋ ₌ ₍ ₎ )

  • a full superscript Latin lowercase alphabet except q ( ᵃ ᵇ ᶜ ᵈ ᵉ ᶠ ᵍ ʰ ⁱ ʲ ᵏ ˡ ᵐ ⁿ ᵒ ᵖ ʳ ˢ ᵗ ᵘ ᵛ ʷ ˣ ʸ ᶻ )

  • a limited uppercase Latin alphabet ( ᴬ ᴮ ᴰ ᴱ ᴳ ᴴ ᴵ ᴶ ᴷ ᴸ ᴹ ᴺ ᴼ ᴾ ᴿ ᵀ ᵁ ⱽ ᵂ ) - no C, F, Q, S, X, Y, Z

  • a few subscripted lowercase letters ( ₐ ₑ ₕ ᵢ ₖ ₗ ₘ ₙ ₒ ₚ ᵣ ₛ ₜ ᵤ ᵥ ₓ )

  • and some Greek letters ( ᵅ ᵝ ᵞ ᵟ ᵋ ᶿ ᶥ ᶲ ᵠ ᵡ ᵦ ᵧ ᵨ ᵩ ᵪ ).

Note that since these glyphs come from different ranges, they may not be of the same size and position, depending on the typeface.

share|improve this answer
Sorry, but my superscript is not limited to these 3 numerals. – Ashwin Nanjappa Jul 7 '11 at 14:02
Any solution for superscript text (alphabet) characters? :-) – Ashwin Nanjappa Jul 7 '11 at 14:42
hey man, all solved! unicode has support to super and subscripts "for cut-and-pasting purposes" with some limitations. so copy and paste :) – kokbira Jul 11 '11 at 18:59
Kokbira: My original problem is solved with your answer :-) – Ashwin Nanjappa Jul 13 '11 at 2:27
Absolutely loving the HOT TRICK section :-) – YGA Mar 24 '12 at 2:18

You could cheat by using a picture of worksheet cells that have your superscript formatting. In the graphic below, the picture of the worksheet cells is outlined in red, and is pasted over the legend (outlined in blue).

But I think you're correct that the legend itself can't show superscripts.

enter image description here

share|improve this answer
If there is no elegant way out, I will have to use this :-) – Ashwin Nanjappa Jul 7 '11 at 14:03

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .