How to Get Subscript in Excel Graphs: A Step-by-Step Guide

Adding subscript in Excel graphs can be a bit tricky, but it’s totally doable with a few simple steps. It’s all about knowing where to look and what buttons to press. After you’ve completed the task, your graph will have that professional, polished look that’ll make your data stand out.

Once you’ve added subscript to your Excel graph, you’ll notice that your text is more readable and your graph looks more professional. This can be especially important when you’re presenting your data to others, or when you’re trying to make a complex point more understandable.


When working with data in Excel, one of the most effective ways to communicate your findings is through graphs and charts. They say a picture is worth a thousand words, and an Excel graph can tell a complex data story at a glance. But sometimes, the default graph settings just don’t cut it. Maybe you’re dealing with chemical formulas that require subscript, or you want to include a footnote in your graph. That’s where knowing how to get subscript in Excel graphs comes into play.

The ability to add subscript (or superscript) to text in Excel graphs is crucial for anyone working with scientific data, mathematical equations, or any other field that requires specialized notation. Whether you’re a student presenting a project, a researcher sharing findings, or a business analyst reporting on market trends, mastering this skill can set your work apart. So, let’s dive in and get those graphs looking exactly how you need them to.

Step by Step Tutorial: Adding Subscript in Excel Graphs

Before we begin, it’s essential to clarify what these steps will help you achieve. By following these instructions, you’ll be able to format specific text within your Excel graph legends, axis labels, and data labels as subscript.

Step 1: Select the Text You Want to Format

Click on the text within your graph that you need to format as subscript.

Once you’ve selected the text, a formatting bar or menu will appear. This is where you’ll find the options to change your text to subscript.

Step 2: Access the Format Cells Dialog Box

Right-click on the selected text and choose ‘Format Cells’ from the context menu.

The Format Cells dialog box is where Excel houses all of its text formatting options including font style, size, and special formatting like subscript and superscript.

Step 3: Choose the Subscript Option

In the Format Cells dialog box, go to the ‘Font’ tab, then check the ‘Subscript’ box under ‘Effects’.

After checking this box, you’ll see a preview of how the text will appear. Make sure you’re happy with it before proceeding.


Improved ReadabilityAdding subscript makes your Excel graphs easier to read and understand, especially when using formulas or specific scientific notation.
Enhanced ProfessionalismGraphs with proper subscript appear more polished and professional, which is essential when presenting your data to others.
Greater AccuracyUsing subscript ensures that your graphs convey information accurately, maintaining the integrity of your data.


Limited Formatting OptionsExcel doesn’t allow for as much customization in subscript formatting as it does with regular text.
Time-ConsumingIt may take a bit of time to format each piece of text individually, especially in complex graphs.
Potential for ErrorsIf not careful, you might apply the subscript format to the wrong part of the text or miss it entirely.

Additional Information

It’s worth noting that Excel does not currently support the use of keyboard shortcuts for subscript in graphs as it does in cells. This means you’ll have to use the Format Cells dialog box each time you want to add subscript. However, once you get the hang of it, it becomes second nature.

Remember, attention to detail can make a significant difference in how your data is perceived. Subscript in Excel graphs is just one of those details that can elevate your work.


  1. Select the text in the graph you want to format.
  2. Access the ‘Format Cells’ dialog box by right-clicking the selected text.
  3. Check the ‘Subscript’ box under the ‘Font’ tab to apply the formatting.

Frequently Asked Questions

Can I use a keyboard shortcut to add subscript in Excel graphs?

Unfortunately, Excel does not currently support keyboard shortcuts for adding subscript in graphs. You’ll need to use the Format Cells dialog box.

Does this method work for superscript as well?

Yes, the same steps apply for adding superscript; just check the ‘Superscript’ box instead of ‘Subscript’ in the Format Cells dialog box.

Can I apply subscript to multiple pieces of text at once?

You can apply subscript to multiple text elements in a graph by holding down the CTRL key and selecting each piece of text before right-clicking and choosing ‘Format Cells’.

What if I only want to format part of the text?

If you only need to format part of the text, simply highlight the specific characters that need to be subscripted before following the steps outlined above.

Will my subscript formatting carry over if I copy the graph to another program?

Subscript formatting should carry over when copying and pasting between Microsoft Office programs, but it may not translate perfectly to non-Microsoft software.


Mastering how to get subscript in Excel graphs is a skill that can subtly, yet significantly, improve the clarity and professionalism of your data presentations. While Excel doesn’t make it as straightforward as we might like, knowing how to navigate the Format Cells dialog box opens up a world of possibilities for formatting text in your graphs.

Whether you’re a student, scientist, or business professional, taking the time to polish your graphs can have a profound impact on how your work is received. So go ahead, get subscripting, and watch your graphs transform from average to exceptional.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy