Subscript in Excel Legend: Use Unicode or Rich Text

Charts & pivot tables · Updated November 20, 2026

To put a subscript in an Excel chart legend, either use a Unicode subscript character in the series name, such as the ₂ in CO₂, or hide the automatic legend and build a text-box legend with only the required characters formatted as subscript. The Unicode method is quickest; the text-box method works when you need a letter or number that Unicode does not provide in a usable form. Excel does not provide a dependable way to format just part of an automatically generated legend entry as subscript.

A chart legend displays the names of its data series. That means the text you need to change is the series name, not the chart title or the worksheet cell’s number format. Before starting, decide whether a Unicode character will do the job or whether you need full typographic formatting. The instructions below are for Excel for Microsoft 365 on Windows.

What You’ll Need

  • An Excel chart with a legend and a series name you can edit.
  • The intended label, such as CO₂, H₂O, or xₙ, and a way to enter the subscript character if you use Unicode.
  • For the custom-legend method, a chart area with room for a text box and, if needed, manually drawn legend markers.

Step-by-Step

  1. Identify the series name shown in the legend. Click the chart once, then look at its legend. Each legend entry corresponds to a data series. If the chart has multiple entries, note which one needs the subscript. Changing a series name changes the corresponding legend text; it does not change the worksheet values or the series data.
  2. Choose between a Unicode character and a custom legend. Use Unicode if the subscript you need is available as a character and a slightly different font appearance is acceptable. For common chemical labels, characters such as ₀, ₁, ₂, ₃, and ₄ are usually convenient. Use a custom legend if you need a subscript letter or a number that is not represented adequately, or if exact typographic formatting matters. You can also check the font used in the chart, because some fonts display certain Unicode subscripts more clearly than others.
  3. For the Unicode method, enter the subscript in a worksheet cell. If the series name already comes from a cell, edit that cell and replace only the relevant character. For example, change the text CO2 to CO₂, keeping the 2 as the Unicode subscript-two character. The cell contains text; this does not perform a calculation or alter any chart data. If the chart uses a series name entered directly in its settings, you can use the same character in that setting instead.
  4. Find and insert the character if you cannot type it. On Windows, open Start and search for Character Map, choose a font that supports the symbol, locate the subscript character, and copy it. Paste it into the worksheet cell or series-name field. You can also copy a correctly rendered character from a trusted source. Avoid relying on an Alt-code unless you have confirmed the code and input method for your Windows setup; different codes and keyboard configurations can produce unexpected characters. On Mac, use the Character Viewer, commonly opened with Control-Command-Space, then search for the character and insert it.
  5. Update the series name if it is entered in the chart. Select the chart and choose Chart Design > Select Data. Under Legend Entries (Series), select the series and click Edit. In the Series name box, either type the revised label or select the cell containing it. Click OK, then click OK again to close Select Data. Check the legend: it should now show the Unicode subscript. If the series name is already linked to a cell, editing the source cell is usually simpler and helps keep the label consistent elsewhere in the workbook.
  6. Check the appearance at the final chart size. Excel may render a Unicode subscript at a slightly different size or baseline from a true formatted subscript. Resize the chart or change its font only after checking that the character remains legible. If it looks like a regular-sized digit, a missing box, or an unrelated symbol, try another font that supports the character or use the custom method below.
  7. For a custom legend, first preserve the series identity. Decide which series the legend describes and note its color, line style, or marker. You will recreate that cue beside the new text, so viewers can still match the label to the correct data. If there are several series, write down each label and its visual style before hiding the original legend.
  8. Hide the automatic legend. Select the chart legend and press Delete, or use the chart’s Add Chart Element controls to turn the legend off. Take care to select the legend rather than the whole chart; if the entire chart disappears or a data series is removed, undo immediately and select the legend more carefully. Removing the legend display does not delete the underlying series.
  9. Add a text box for the replacement label. Select the chart, choose Insert > Text Box, and draw the box where the legend entry should appear. Type the full label, for example CO2, and place the insertion point in the text box. Drag across just the 2 so that only that character is selected. Do not select the whole label, or the entire text will be changed.
  10. Apply subscript to the selected character. With only the character selected in the text box, open the Font dialog from the Home tab’s Font group by clicking its small dialog launcher. In the Font dialog, select the Subscript effect and confirm. The selected character should sit lower and appear smaller than the surrounding text. If your Excel build presents text formatting differently for a selected shape, keep the text selected and use the Font controls available on the Home tab; the important point is to apply the effect to the selected character, not to the whole text box.
  11. Format the replacement so it reads like a legend. Match the text’s font and approximate size to the chart labels. If the original legend used a colored line or marker, add a small line or shape beside the text using Insert > Shapes, then set its color and style to match the data series. Align the marker and text, and group them if convenient. Repeat for other series only if you are replacing the complete legend.
  12. Test and save the chart. Click outside the text box, inspect the label at normal viewing size, and confirm that the right series is identified. If the chart will be resized or copied, check the position again. Save the workbook, then reopen it if the chart is important to a report or presentation to confirm that the font and placement remain as intended.

Common Mistakes

Formatting the worksheet source cell and expecting the legend to inherit it. Making one character in the source cell subscript does not reliably apply that partial-character formatting to the automatically generated legend. The chart legend uses the series name, but its text formatting is controlled separately. Use a Unicode character in the name, or create a custom text box when you need true character-level formatting.

Changing the data instead of the series name. A chemical label such as CO₂ is text. Do not change a numeric data value to try to affect the legend. Edit the series name through Select Data or its linked source cell, leaving the chart’s values and ranges alone.

Applying Subscript to the entire label. In a custom text box, confirm that only the intended character is highlighted before choosing the Subscript effect. If all the text is selected, Excel will lower and shrink all of it. Undo, select just the correct character, and apply the effect again.

Using a plain digit or an unrelated symbol. A normal 2 is not a subscript, and some fonts show Unicode characters as empty squares. Confirm the exact character and view it in the chart font. A Unicode subscript letter may not exist or may be poorly supported, so do not assume every letter has an equivalent.

Deleting the wrong chart element. Pressing Delete while the chart area or a data series is selected can have a different result from deleting the legend. Click the legend border or a legend entry until the legend itself is selected. If the chart changes unexpectedly, undo rather than trying to reconstruct the chart from memory.

Tips

For common scientific notation, Unicode is often the best balance of speed and reliability. It keeps the legend automatic: when the series name changes in its source cell, the legend updates too. Save frequently used labels in a small reference sheet, or copy a known-good character from an existing label, so you do not have to search for it each time.

When using a custom legend, make it clear that the text box is a replacement rather than an extra annotation. Position it near the chart’s plot area and match the built-in legend’s color and font as closely as possible. If the chart has several series, reproduce every legend entry, not only the one containing a subscript, so readers do not have to compare two different legend styles.

Keep an automatic legend if it needs to respond to frequent changes in series names or chart layout. A manually created text box can move out of place when the chart is resized, and its text does not automatically follow edits to a source cell. If the chart is part of a dashboard, test the custom legend after changing chart dimensions and after printing or exporting to PDF.

On Mac, the Chart Design and Select Data workflow is similar, though ribbon layout and some dialogs can vary by Excel release. Unicode characters can also be inserted with Character Viewer. In Excel for the web, a Unicode character in the series-name cell is generally the more straightforward option; rich text editing of a text box may be limited compared with the desktop application. If character-level formatting is unavailable in your web session, open the workbook in desktop Excel and format the text box there.

Troubleshooting

The legend did not change after editing a cell. The chart may use a different cell for its series name, or the name may have been typed directly into the chart settings. Select the chart, open Chart Design > Select Data, select the series, and click Edit. Check the Series name field to see whether it points to a cell or contains a typed label. Edit the actual source, then confirm the change.

The subscript shows as a box or question mark. The selected font may not contain that Unicode glyph, or the character may not have pasted correctly. Try a broadly supported font such as Arial or Calibri and reinsert the character. If it still fails, switch to the custom text-box method, which formats an ordinary character rather than relying on that particular Unicode glyph.

The custom label will not let you select one character. Click inside the text box to edit its text, then drag over the character itself. A single click may select the shape rather than enter text-editing mode; click again inside the text or use the text cursor. If the Font dialog is unavailable, verify that the text—not just the text-box outline—is selected, or open the workbook in desktop Excel.

The replacement legend moves when the chart changes size. The text box or marker may not be positioned or sized with the chart. Move it back into place and adjust the box dimensions. If the chart will be resized often, use Unicode in the automatic legend where possible, since the automatic legend is more likely to remain correctly arranged.

The subscript looks too low or too small. Unicode glyphs have a design set by the font and cannot always be adjusted independently inside the automatic legend. Try a different font or use a custom text box and adjust the selected character’s font size after applying subscript. Check the chart at the size readers will actually see, not only while zoomed in.

Frequently Asked Questions

Can I make only one character in an automatic Excel legend subscript?
Excel does not provide a reliable character-by-character subscript control for the standard automatic legend. Use a Unicode subscript in the series name, or replace the automatic legend with a formatted text box.

Will formatting the series-name cell make the legend subscript?
Not reliably. Partial rich-text formatting in the worksheet cell is not a dependable way to format the corresponding legend entry. Put a Unicode subscript character in the series name, or format a replacement text box.

How do I type CO₂ in Excel?
Enter CO followed by the Unicode subscript-two character, ₂, in the series-name cell or series-name field. You can copy the character from a reference, use Character Map on Windows, or use Character Viewer on Mac.

Can I use a subscript letter instead of a number?
Some Unicode subscript letters exist, but the set is incomplete and font support varies. If the exact letter is unavailable or displays poorly, use a custom text box and apply the Subscript effect to that character.

Does the custom text-box legend update when chart data changes?
The text box does not automatically track edits to the series name, and its marker and placement may need maintenance. Keep the automatic legend when automatic updates matter, and use a Unicode subscript if its appearance is acceptable.

Does this work in Excel for the web?
Unicode in a series-name cell is usually the simplest web-friendly approach. For precise character formatting in a replacement text box, use desktop Excel if the web app does not expose the required Font controls.

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.