sub or superscripts in category axis

D

diane k

How do I format a category axis so that I can properly display chemical formulas? (like H2O, the 2 needs to be a subscript, but the rest of the letters need to be normal text? I can format the whole thing as sub or superscript, but that's not what I want to do.
 
T

Tushar Mehta

Use a text box. Select the chart. Type H20. XL will automatically
create a text box within the chart. Position it as desired. Select
the text, pause, then select just the 2. Select Format | Selected
Object... and from the Font tab select the Subscript option.


--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub/Superscripts in Autocorrect 2
category label spacing (x-axis generally) 2
Scatter chart with categories on x-Axis 2
How do I add subscripts to chart labels in Excel? 2
Sub/Superscripting should work in Excel Legends/Axis Labels 0
Superscripting text in a cell 3
WordPerfect to Word Conversion Footnote Problem 0
Superscripts removed when applying style 1

Top