Superscripts & Subscripts in Excel Graphs/Charts

preview_player
Показать описание
Learn how to type "subscript" & "superscript" in excel graphs/charts using 4 different methods. We will cover how to include subscript/superscript in Chart title or Axis title or Chart legend.
★★★★★

Index for this video is shown below. Feel free to move to the respective sections by clicking on the timestamp!

02:35 - Adding superscript/subscript in Chart/Graph title (3 different methods).
03:07 - Method 1 - The quick character shortcut (Only works for Degree and Superscripts 1,2,3).
03:27 - Method 2 - Copy paste superscript/subscript into Chart/Graph title.
04:34 - Method 3 - Excel Shortcuts (2 shortcuts each for superscript/subscript)
05:18 - Adding superscript/subscript in Chart/Graph Axis title. (This is same as how you type superscript/subscript in Chart Title, However, I show one example using shortcut)
06:13 - Adding superscript/subscript in Chart/Graph Legend. (We discuss about 2 implementation methods that don't work in this case and why. Subsequently, we look at 2 methods that work.
07:06 - Why Excel navigation shortcut wont work in Legends.
08:05 - Method 1 - Copy paste superscript/subscript into Chart/Graph title.
08:39 - Method 2 - The quick character shortcut (Only works for Degree and Superscripts 1,2,3).
09:46 - Typing degree symbol in Chart/Graph Axis title.
10:11 - Typing degree symbol in Chart/Graph Legend.

The Unicode character link referred in this video is...

★★★★★
Superscript/Subscript examples referred in this video. Note that you can use the mentioned methods to include ANY subscript/superscript characters.

In this video, I walk through the below examples
1. Typing meter squared (m²) in excel chart/graph title.
2. Typing m² in excel chart/graph axis title.
3. Typing m² in excel chart/graph legend.
4. Typing ºF (degree symbol) in excel chart/graph axis title.
5. Typing ºF (degree symbol) in excel chart/graph axis legend.

The 4 methods to implement superscript/subscript in Graphs/Charts discussed in this video are...

Using Method 1 (quick shortcuts), you can type superscripts like x¹, x², x³ or infinity symbol like x∞ or degree symbol like ºF. This will work in Chart/Graph title and Chart/Graph axis title and even in Chart/Graph legend.

For ∞ (infinity symbol), use quick shortcut ALT+236.
For ¹, use ALT+0185
For ², use ALT+0178
For ³, use ALT+0179
For °, use ALT+0176

Using Method 3 (superscript/subscript shortcuts), you can convert any existing text to superscript/subscript. This method will work in Chart/Graph title and Chart/Graph axis title. However, it will not work for Chart/Graph legends. Below are the shortcuts

Shortcut 1: (Superscript) ALT HFNP/ (Subscript) ALT HFNB
Shortcut 2: (Superscript) CTRL+1, ALT P, (Subscript) CTRL+1, ALT B

Using Method 4 (Subscript Implementation, the manual way). This will work ONLY for Chart/Graph legends as you need to format the column title to make it reflect in chart legend. This method cannot be used to implement superscripts/subscripts in Chart/Graph Title or Chart/Graph Axis title.

For Subscript
Step 1: Select the text that needs to be converted into a subscript.
Step 2: Right Click
Step 3: Select 'Format Cells'
Step 4: Check 'Subscript' checkbox.
Step 5: Click OK.

For Superscript
Step 1: Select the text that needs to be converted into a superscript.
Step 2: Right Click
Step 3: Select 'Format Cells'
Step 4: Check 'Superscript' checkbox.
Step 5: Click OK.

#excelsubscriptcharts #excelsuperscriptcharts #learn365club

Рекомендации по теме
Комментарии
Автор

Gr8 help spent a full day trying to figure out how to change the name of the variable, you saved the day thanks :)

esraamakled
Автор

Easily explained. Thank you so much!!!

shantaislam
Автор

Thank you i was unable to add a subscript to data labels in the chart i.e. GA3 etc. it helped a lot.

vishwanathiari
Автор

Can you tell me how to add subscript/superscript in axis data?

simusworld
Автор

Sir, van you tell me how to subscript b in axis, as it does not have any Unicode for subscript

mohitsinghparihar
Автор

Thank you! I searched for the legend superscript!

Digidori
Автор

Thanks for this video, you saved my day🙏
The copying method helped me to edit the legends.
Can you tell from where you got the superscript and subscript fonts used for copying. I copied it from your sheet.

sanmitradan
Автор

My man, this worked perfectly! Thanks so much!

robskalas
Автор

How to change in axis elements? As for example in your graph if you need to add superscript in location name how could you change it?

ajahan
Автор

Thank you so much sir 🙏🙏🙏🙏.. very informative video 👌👌👌👏👏👏👏

neerajtejwan
Автор

Thank you for this great video, I want to write italic rather than superscripting. Could you please tell me how to do that? Thanks in advance

sebooz
Автор

How to add Greek symbol in excel chart.? Thanks

rahulkumargarg
Автор

But is it possible to superscript in the chart legend letters like b or c or you can only have some specific numbers and symbols????thanks

christosd
Автор

how to do subscript in horizontal axis ...e.g. TiO2 ....in TiO2, 2 should be in subscript.

DharmendraKumar-yoji
Автор

What if the subscript I want to put in the index of "X" for example if I had a list of chemical components that I want to look like SO4 or H20

miguelangelperezgarcia
Автор

I have this word (SCC-CKD10%), (SCC-CKD20%) and (SCC-CKD30%) how tom make just 10%, 20% and 30% Superscript in the legend ? thans for the video

moussabalqaissy
join shbcf.ru