Superscript in Excel Chart Legends: Methods That Work

Charts & pivot tables · Updated November 20, 2026

To show superscript in an Excel chart legend, put the superscript character directly in the series name—usually the chart’s source header cell—for example, change a label to Rate (s⁻¹) or Area (m²). Excel does not reliably carry character-level superscript formatting from a worksheet cell into a chart legend, so Unicode superscript characters are the simplest dependable option; a manually built legend is the alternative when you need precise formatting.

How chart legend text works

A chart legend identifies the plotted data series. In a typical chart, each legend entry gets its name from the series name, which is often linked to a heading in the worksheet. For example, if a column chart uses the heading in cell B1 as the name of the series, changing that heading can change the matching legend entry too. A series name can also be set separately in the chart’s data settings.

Formatting the worksheet heading and formatting the legend are different operations. You can select characters in a worksheet cell and apply the Superscript effect through the Font settings, but that rich-text styling is not a dependable way to create a superscript in the chart legend. The chart uses the series name as text; it does not reliably reproduce the header cell’s character-by-character font effects. The character itself, however, is part of the text and can be displayed in the legend.

This distinction explains why a cell can visibly show a raised 2 while its legend entry shows an ordinary 2. If the chart legend must contain a raised number or symbol, use the corresponding Unicode character in the series name, or create a separate legend with text boxes.

Use a Unicode superscript in the series name

For common exponents and notes, Unicode superscript characters are quick and work in the series name just like other text. Examples include m², x³, s⁻¹, and a¹. These are characters with superscript-like shapes, not ordinary numerals with Excel’s Superscript font effect applied. Their appearance can vary slightly with the font used by the chart, but they generally remain raised in the legend.

  1. Identify the worksheet cell or series setting that supplies the legend entry. If the chart uses a header cell, edit that cell; for example, change Area to Area (m²).
  2. Enter or paste the superscript character into the name. You can copy a suitable character from a reliable source, or in Excel for Microsoft 365 on Windows use Insert > Symbol to find a character in an available font.
  3. Check the chart legend. If the series name is linked to the edited header, Excel should update the entry. If it does not, use Chart Design > Select Data, select the series under Legend Entries (Series), choose Edit, and set Series name to the intended cell or text.
  4. Review the result at the chart’s intended size and in the font used by the chart. A character that is legible at full size may be hard to distinguish in a small legend.

On Mac, Unicode characters can also be entered or pasted, though the symbol picker and ribbon layout may differ from Windows. In Excel for the web, editing the series name or typing the character into its source cell is often the most straightforward approach; some chart-formatting controls differ from desktop Excel. The key point is the same in each environment: the superscript-shaped character must be part of the series name.

Which characters work well?

Unicode includes superscript numerals such as ⁰, ¹, ², ³, ⁴, ⁵, ⁶, ⁷, ⁸, and ⁹, along with some superscript operators and letters. The set is not a complete, consistently styled alphabet. If you need a particular letter or a complex mathematical expression, check that the exact character exists and that the chart font displays it as intended. A missing glyph can appear as a box or an unexpected substitute.

  • Units: m² can represent square metres, and s⁻¹ can indicate a reciprocal second.
  • Scientific notation: a label such as 10⁶ can show a raised exponent when that is clearer than a longer explanation.
  • Series notes: Sales¹ can point readers to a note elsewhere, provided the note is clearly explained.
  • Do not confuse superscript and subscript: CO₂ uses a subscript 2, while x² uses a superscript 2. The position changes the meaning in many scientific labels.

Unicode superscripts are characters, not a formatting command. That makes them portable in chart names, but it also means they may not behave like ordinary numbers in every context. For example, a reader copying a label or using assistive technology may encounter the character’s Unicode name or an interpretation that differs from its visual meaning. For essential units or notes, include enough plain-language context in the chart title, axis title, caption, or accompanying text.

Change the name through Select Data

If the legend name is not coming from an obvious heading, set it through the chart’s data source settings. In Excel for Microsoft 365 on Windows, select the chart, open Chart Design > Select Data, choose the relevant series in the Legend Entries (Series) list, and select Edit. The Series name field lets you point to a worksheet cell or enter a name. Using a cell reference is often easier to maintain than typing the name into the chart dialog, because changing the cell later can update the legend automatically.

For instance, suppose a chart has a series named Temperature and you want it to read Temperature (°C)¹. Put that complete text, including the superscript 1, in the series-name cell and confirm that the series uses that cell. The chart’s plotted values do not change; only the descriptive name shown in the legend changes. If several series have similar labels, use Select Data to verify that you edited the correct one.

Do not expect a superscript effect applied to only one character in the source cell to transfer. If you have already formatted a header that way, the quickest fix is to replace the relevant character with its Unicode superscript equivalent. You may keep the worksheet cell’s visual formatting for other purposes, but the legend’s raised character should be in the actual name text.

When to build a custom legend

Use a custom legend when Unicode cannot express the required label, when the legend needs a complicated mix of font sizes and positions, or when precise visual control matters more than automatic updating. In Excel, hide or remove the built-in legend, then add text boxes and, if useful, small colored shapes to identify the series. With text selected inside a text box, use the Home tab’s Font controls or the Font dialog to apply Superscript to selected characters. This formats the characters visually rather than relying on a superscript Unicode glyph.

A manual legend is not automatically tied to the chart’s series in the same way as the built-in legend. If you add, remove, rename, or recolor a series, you may need to update the text and the sample shapes yourself. Match each swatch to the corresponding line, bar, or marker, and test that the legend remains clear when the chart is resized or printed. For a workbook that changes frequently, this maintenance can outweigh the extra formatting control.

A practical compromise is to use a built-in legend with Unicode labels for routine charts and reserve a custom legend for a final, stable report graphic. If the chart will be copied into a presentation or document, check the appearance after pasting because fonts, scaling, and the display of less common Unicode characters can vary between applications.

Common problems and fixes

  • The legend shows a normal-sized number. The source cell may contain an ordinary numeral with superscript formatting. Replace that numeral in the series name with a Unicode superscript character.
  • The chart does not change after editing a heading. The series may use a different name reference or a name entered directly in the chart. Check Chart Design > Select Data > Edit for that series.
  • The character appears as a square. The selected font may not support that glyph. Try a common font available on the target devices, or use a custom legend with ordinary text and formatting.
  • The superscript is too small or visually ambiguous. Increase the legend font size, choose a clearer character, or explain the notation in a nearby title or note. A raised character should not be the only clue to a critical measurement convention.
  • Only one legend entry needs the change. Each series has its own name. Edit that series name, not the overall legend font, which affects the legend’s general appearance.

Also distinguish changing the label from changing the data. Editing a series name changes how the series is identified; it does not apply an exponent to the values or alter calculations. If values themselves need a mathematical transformation, perform that calculation in the worksheet and label the resulting series accurately.

Choosing the right method

For a short, familiar notation such as m², use a Unicode character in the series name. This keeps the chart legend connected to its data and requires little upkeep. For a special character not available in Unicode, or for an equation with several differently formatted parts, a custom text-box legend provides more control but needs manual maintenance. If the raised character is only explanatory, a footnote in a caption may be clearer than squeezing it into a narrow legend.

Consider who will read the chart and where it will appear. A small superscript may be easy to see on a large monitor but less clear in a printed report, a screenshot, or a mobile view. Check the chart in its final format, retain a clear text explanation for important notation, and avoid using superscript solely to make a label look decorative when it could be mistaken for a unit or exponent.

Frequently Asked Questions

Can I format just one character in an Excel chart legend as superscript?
Not reliably through the normal chart-legend formatting controls. Use a Unicode superscript character in the series name for a built-in legend, or create a custom text-box legend and format selected characters there.

Why does superscript formatting in my worksheet header disappear in the legend?
The chart legend uses the series name as text and does not reliably carry over character-level formatting from the source cell. Put the superscript character itself in the cell or series name instead.

Can I type a superscript directly into a legend entry?
The built-in legend reflects series names rather than serving as a normal editable text box. Change the series name through its source cell or Select Data. For freely editable legend text, use a separate text box.

Will a Unicode superscript display on another computer?
Usually, if the other computer’s font supports the character, but its appearance can differ by font and application. Check the chart on the devices or in the exported format that matter to your readers.

Is ² the same as applying Excel’s Superscript effect?
No. ² is a Unicode character that looks like a superscript two. The Superscript effect changes how a regular character is drawn. The Unicode character is generally more reliable in a legend because it is part of the series-name text.

Can I use this method for subscripts too?
Yes, if a suitable Unicode subscript character exists, include it in the series name just as you would a superscript. For example, CO₂ contains a subscript 2. Check the displayed result and explain technical notation when readers may not recognize it.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.