how to add subscript in a chart legend?
 

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?

Answer: how to add subscript in a chart legend?
 

Yes, you can add subscript in a chart legend in Excel 2007. Here's how:

1. Double-click on the chart to open the Chart Tools tab.
2. Click on the Layout tab.
3. Click on the Legend dropdown menu and select Legend Options.
4. In the Format Legend dialog box, click on the Legend Key tab.
5. Click on the label you want to add subscript to.
6. In the Label Contains section, click on the Custom radio button.
7. Type the label text in the text box, and where you want to add subscript, type an underscore (_) followed by the subscript text.
8. Click OK to close the Format Legend dialog box.

Your chart legend should now display the label with the subscript text. Repeat these steps for any other labels you want to add subscript to.

how to add subscript in a chart legend?
 

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

Mecckey wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

how to add subscript in a chart legend?
 

To facilitate this task:

http://www.tech-archive.net/Archive/.../msg00189.html

Ask please if you find the description difficult to understand.
--
Petr Bezucha


"Andy Pope" wrote:

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

Mecckey wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

how to add subscript in a chart legend?
 

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

how to add subscript in a chart legend?
 

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/ti...%20textbox.pdf



On Tue, 27 May 2008 11:43:00 -0700, Mecckey
wrote:

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?