subscripts in chart legends

[Matthew R]

Is there a way to have individual characters in a chart
legend as subscripts? I cna make the entire entry a
subscript, but I only want a single character.

 

[Debra Dalgleish]

Jon Peltier has an ASCII table in an Excel file that you can download
from his web site:

http://www.geocities.com/jonpeltier/Excel/tricks.html

The code for superscript 2 is Alt+0178

 

[Andy Pope]

Hi Michele,

I don't believe their is a keystroke combination for SUBscript characters.
But, as Debra suggest, check out Jon's example.

This is the exact question I was going to post. You
mentioned superscript characters, would you know the
subscript characters for 2?

Thanks for your help.




characters in the legend


directly in your text,


with the Show


have there


position the data

--

Cheers
Andy

http://www.andypope.info

 

[Michele]

Thanks for your quick reply, but I need SUBscript, so
that I can use it for an Oxygen symbol. Thanks.

 

[Andy Pope]

Hi,

A previous suggestion was to download a suitable font.
I have not personally tried this, but it may help.
(http://www.scs-intl.com/frameload.htm?/chemfont.htm)

Another suggestion was to use the font 'Lucida Sans Unicode'
inconjuction with the Character Map program.

or as stated previously, use data labels to create your own legend.

If someone does have the answer, I'd be interested too! I can set up
chemical formulae in Word (to be truthful, my son wrote me a macro for this
a long time ago!) and even copy them to Excel cells with the subscripts
preserved but the different formatting disappears when the cells are used as
chart legends.

--

Cheers
Andy

http://www.andypope.info

 

[James Silverton]

Hi,

A previous suggestion was to download a suitable font.
I have not personally tried this, but it may help.
(http://www.scs-intl.com/frameload.htm?/chemfont.htm)

Another suggestion was to use the font 'Lucida Sans Unicode'
inconjuction with the Character Map program.

or as stated previously, use data labels to create your own legend.

Tho' there are an impressive number of characters available when Unicode is
selected in "Insert Symbol", I cannot do anything more with Lucida Sans
Unicode than with other fonts. (Perhaps I'm missing something!) In addition
to copying from Word, I can build a chemical formula with subscripts in a
cell but that reverts to a single font size if used to make a chart title or
label. I must look into the font you mentioned.

It would be useful to have subscripts readily available without using more
specialized scientific programs but I have seen no indication that they will
be there in the next model of Office.

Jim.

 

[James Silverton]

Tho' there are an impressive number of characters available when Unicode is
selected in "Insert Symbol", I cannot do anything more with Lucida Sans
Unicode than with other fonts. (Perhaps I'm missing something!) In addition
to copying from Word, I can build a chemical formula with subscripts in a
cell but that reverts to a single font size if used to make a chart title or
label. I must look into the font you mentioned.

It would be useful to have subscripts readily available without using more
specialized scientific programs but I have seen no indication that they will
be there in the next model of Office.

Jim.

I am grateful to Andy Pope for the suggestion. I downloaded Chemfont and it
*is* a useful addition to my installed fonts. Unfortunately, if used for a
title or legend, the subscripted characters appear as empty square boxes on
the chart. It is a long time since I last looked at the finer details of
fonts but I guess, tho' Chemfont is True Type, it is not an "Open" font.

Jim

 

[Jon Peltier]

James -

I've hacked code for data labels to adjust formats within a data label.
If the cell displays a label with supers and subs, you can put the
text of the cell into the data label, then character by character, apply
the formatting of the cell to the label. Tedious, but that's why god
invented macros.

- Jon