how to add subscript in a chart legend?

[Mecckey]

I am using Excel 2007. I cannot write a word with sub- or super- script in
the chart legend. Is there any way to do it?

 

[Andy Pope]

Hi,

You can not have individual characters formatted in a legend.
You would need to use a special font where the required characters are
formatted with sub or superscript.

Cheers
Andy

 

[PBezucha]

To facilitate this task:

http://www.tech-archive.net/Archive/Excel/microsoft.public.excel.charting/2007-07/msg00189.html

Ask please if you find the description difficult to understand.

 

[Dave Curtis]

Hi,

You can get round this problem by making a "dummy" legend inside the plot
area using an additional x-y series and adding data labels. You can then
format individual characters within the data label.

Dave

url:http://www.ureader.com/msg/10296103.aspx

 

[Tushar Mehta (Microsoft MVP Excel 2000-2008)]

Whether the below technique is worth the effort is something you have
to decide

Case Study – Incorporate worksheet information in a chart
http://www.tushar-mehta.com/excel/tips/0202-dynamic chart textbox.pdf