subscripts in chart legends

  • Thread starter Thread starter Matthew R
  • Start date Start date
M

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.
 
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Thanks for your quick reply, but I need SUBscript, so
that I can use it for an Oxygen symbol. Thanks.
 
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.


James said:
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.
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Andy Pope said:
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.
Click to expand...


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 said:
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.
Click to expand...

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
 
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
 
Back
Top