how to add subscript in a chart legend?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mecckey - 27 May 2008 19:43 GMT

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?

Reply to this Message

Andy Pope - 27 May 2008 19:57 GMT

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

> 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?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

PBezucha - 28 May 2008 06:20 GMT

To facilitate this task:

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

Ask please if you find the description difficult to understand.

Signature

Petr Bezucha

> Hi,
>
[quoted text clipped - 7 lines]
> > 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?

Reply to this Message

Dave Curtis - 28 May 2008 09:30 GMT

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

Reply to this Message

Tushar Mehta (Microsoft MVP Excel 2000-2008) - 28 May 2008 21:10 GMT

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

>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?

Reply to this Message