Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how to add subscript in a chart legend?

2 views
Skip to first unread message

Mecckey

unread,
May 27, 2008, 2:43:00 PM5/27/08
to
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

unread,
May 27, 2008, 2:57:18 PM5/27/08
to
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

PBezucha

unread,
May 28, 2008, 1:20:00 AM5/28/08
to
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.
--
Petr Bezucha

Dave Curtis

unread,
May 28, 2008, 4:30:06 AM5/28/08
to
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)

unread,
May 28, 2008, 4:10:46 PM5/28/08
to
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

0 new messages