To put a subscript in an Excel graph axis title, select the title text, highlight the character or characters to lower, open the Font dialog, and turn on Subscript. For tick labels, use subscript Unicode characters in the source labels when available; Excel does not apply rich-text formatting to individual tick-label characters in the same way it does to an axis title. These methods work in Excel for Microsoft 365 on Windows and help display notation such as CO₂, H₂O, or a variable with a subscript.
What You’ll Need
- An Excel workbook with a chart. If you are starting from scratch, add a chart from your data using Insert, then choose a chart type.
- A clear idea of where the subscript belongs: in the axis title, such as “Concentration (mol/L),” or in the tick labels, such as chemical names or category names.
- For tick labels, the subscript characters you need. Unicode includes subscript digits and some letters, but not every letter has a standard subscript character.
Step-by-Step
- Identify the text you need to change. An axis title describes an axis, for example “Time (s)” or “Concentration (mol/L).” Tick labels are the individual values or categories along the axis. The method depends on which one contains the notation: character-level formatting is best for an axis title, while Unicode is usually the practical route for category tick labels.
- Add an axis title if the chart does not have one. Select the chart, then choose Chart Design > Add Chart Element > Axis Titles and select Primary Horizontal or Primary Vertical. Click the new title and type the complete wording, including the character that will become a subscript. For a chart with a secondary axis, choose the appropriate secondary-axis title instead.
- Enter or edit the axis title. Click the axis title once to select the title object, then click inside it again to edit its text. Select only the character or characters you want to format. For example, in “CO2 concentration,” select the 2, not the whole phrase. If Excel selects the whole title box rather than the text, click again inside the text or drag across the character while the title is in edit mode.
- Open the Font dialog for the selected text. Keep the character selection active. On the Home tab, in the Font group, select the small dialog box launcher at the group’s lower-right corner. In the Font dialog, under Effects, select Subscript, then select OK. The selected character should sit lower and appear smaller than the surrounding text.
- Check the result and finish editing. Click outside the title, then inspect the chart at its usual viewing size. If the subscript is hard to read, increase the title’s overall font size or make the chart larger. Avoid selecting the entire title when you only intend to lower one character; otherwise, all of the title text may become subscript.
- Use a Unicode subscript for a category tick label. If the axis displays categories taken from worksheet cells, edit the source cell rather than trying to format one character in the chart. Replace the ordinary digit or supported letter with its subscript Unicode counterpart—for example, change “CO2” to “CO₂”—and check that the chart updates. You can copy and paste a character such as ₂ from a reliable character source or use your operating system’s character picker. The exact picker shortcut depends on your Windows setup, so copying and pasting is often simplest.
- Check the cell-to-chart link. If changing a source cell does not change the category label, select the chart and choose Chart Design > Select Data. In the Select Data Source window, inspect the Horizontal (Category) Axis Labels range and make sure it points to the cells you edited. Select Edit to correct the range if needed, then confirm the dialogs.
- Handle numeric value axes differently. A value axis, such as the numbered vertical axis of a scatter chart, generates its tick labels from numeric values. Excel does not provide the same per-character Subscript control for each generated tick label. If you only need a subscript suffix, select the axis, open Format Axis, expand Number, and use a suitable custom number format containing a quoted Unicode character. This adds a suffix; it does not convert the axis’s ordinary digits into subscript digits. For fully custom labels, consider using a category axis or a separate labeling approach, and verify that the chart still communicates the numeric scale accurately.
- Save and review the chart in context. Check the axis title or labels in the workbook and in any exported or printed version. Different fonts and devices can render Unicode characters differently. If a character appears as a box or is too small, try another font that supports it, use a different notation, or use an axis title with rich-text formatting instead.
Common Mistakes
Trying to format a tick label like an axis title: Axis titles are editable text objects, so you can select part of the text and apply Subscript. Tick labels are generally generated from worksheet data or numeric values. For category labels, put the Unicode character in the source cell; for a numeric value axis, do not expect character-level formatting of each tick.
Formatting the whole title by accident: Clicking once selects the title object; a second click or a drag inside the title lets you edit and select text. Confirm that only the intended character is highlighted before opening the Font dialog.
Assuming every letter has a subscript character: Unicode has subscript digits and a limited set of letters and symbols, not a complete, consistent lowercase alphabet. A similar-looking character may not be available or may render differently in your chosen font. Use rich-text formatting in a title when possible, or choose a notation that remains readable.
Changing the chart label but not the source data: A chart may overwrite or refresh labels when its data range changes. Editing the worksheet cell that supplies a category label is more dependable than attempting to type over a displayed tick label.
Using subscript to imply a different scale: Lowering a digit visually is not the same as changing an axis value or its units. Keep the axis scale, units, and explanatory title clear so readers do not mistake notation for a different measurement.
Tips
Use subscript only where it carries meaning, such as the 2 in H₂O or the 2 in x₂. Keep the rest of the axis title at normal size so the notation is easy to scan. If the title includes units, format the relevant character without changing the unit itself; for example, “Area (m²)” is clearer than making the whole unit subscript.
For repeated category labels, prepare the text in the worksheet first and use those cells as the chart’s category labels. This makes the labels easier to audit and update than editing individual chart elements. If you need to enter many Unicode characters, keep a small reference list on a worksheet or use copy and paste; do not assume a font or keyboard layout will provide every subscript directly.
On Windows, the Font dialog launcher on the Home tab is a reliable way to find the Subscript effect. Excel for Mac also supports character formatting in chart text, but the ribbon layout and dialog appearance can differ; use the Font controls available on the Home tab and look for the Subscript effect. Excel for the web may not expose the same detailed character-formatting controls for chart text. If you cannot select and format part of a chart title there, open the workbook in the desktop app. Unicode labels can still work in the web version if the font used to display them supports the characters.
If you need labels such as “10” where both digits are lowered, use the actual Unicode subscript digits in category text when that notation is appropriate. Do not rely on a custom number format to transform the digits themselves: a format can add literal text, but the numeric value remains a normal number and its digits are not individually converted to subscript. For graphs used in reports or publications, check the final exported image or PDF at the intended size.
Troubleshooting
The Subscript option is unavailable or has no effect: Make sure you are editing the title text, not merely selecting the chart or title box. Click inside the title, select the specific character, and reopen the Font dialog. If the text cursor is not visible, click the title again or press Escape and repeat the selection.
The whole axis title changes: Undo the change immediately with Ctrl+Z on Windows (Command+Z on Mac). Re-enter title-edit mode and select only the target character before applying the effect. If undo is no longer available, select the title text and turn off Subscript in the Font dialog, then apply it again to the correct character.
The chart does not show the Unicode label you entered: Verify the cell is actually within the chart’s category-label range using Chart Design > Select Data. Also check that the workbook is recalculated and that the chart has not been set to display a different range. If the character appears as an empty square, choose a font with better Unicode coverage or replace it with a supported notation.
The labels are too crowded or tiny: Subscript characters are smaller by design, and longer labels can overlap. Widen the chart, reduce the number of displayed categories, or shorten labels without removing information readers need. For a numeric value axis, do not force a category-label workaround if it makes the scale misleading; consider clarifying the notation in the axis title instead.
The formatting changes after reopening or sharing the file: Check whether the recipient’s Excel version or font supports the chosen character. Unicode characters are part of the label text, while rich-text formatting is part of the chart title’s formatting; fonts and chart rendering can vary. Embed or choose a widely supported font when possible, and review a PDF or image export before distributing the chart.
Frequently Asked Questions
Can I subscript just one character in an Excel axis title?
Yes. Edit the axis title, select the character, and use the Font dialog’s Subscript effect. This changes the appearance of that character without changing the axis data.
Can I make only one digit in an axis tick label subscript?
Not with the same character-formatting method used for an axis title. For category labels, use a subscript Unicode digit in the worksheet cell that supplies the label. Numeric value axes generate their own tick labels and need a different labeling approach.
Will formatting the worksheet cell make its chart label subscript?
Usually, no. Chart category labels generally take their displayed text from the cell values, but do not inherit character-level font formatting from those cells. Put the subscript character itself in the cell if you need it to appear in a category label.
Can I use a custom number format to make a value-axis number subscript?
A custom number format can add a literal Unicode subscript character, such as a suffix, but it does not convert the numeric digits into subscripts. Use it only when that added suffix accurately represents the scale and notation.
Does this work in Excel for Mac or Excel for the web?
Excel for Mac has chart-text formatting controls, though the ribbon and dialogs may look different. Excel for the web may not offer the same detailed formatting for part of a chart title; use the desktop app if you cannot find the Subscript effect. Unicode characters may display in either version if the font supports them.
Why does the subscript look different on another computer?
Fonts can draw Unicode characters differently, and some fonts do not include every subscript glyph. Use a broadly supported font and check the shared workbook or export on the device where it will be viewed.
Related
- Password-Protect an Excel File So It Can’t Be Opened
- Protect an Excel Workbook From Opening with a Password
- How to Print an Excel Sheet on One Page Without Clipping
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Bubble Chart in Excel: Create, Format, and TroubleshootTo make a bubble chart in Excel for Microsoft 365 on Windows, arrange your data in three numeric…
- Excel Pie Charts With Text Data: What Works and Why?Excel cannot use words alone to set the sizes of pie-chart slices: slice sizes must come from numeric…
- Power Pivot for Beginners: A Practical Excel GuidePower Pivot is an Excel tool for combining data from multiple tables and analyzing it with PivotTables. To…
- How to Insert a Bar Graph in Excel: A Step-by-Step GuideTo insert a bar graph in Excel, select your category labels and values, then choose Insert > Insert…
- Excel Scatter Plot Linear Regression: How to Add a TrendlineTo show a linear regression on an Excel scatter plot, select your numeric X and Y data, choose…
- How to Center Bars in an Excel ChartTo center bars within their category spaces in Excel, select the chart’s category axis, open Format Axis, and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.