Subscrip/Superscript in Excel pPot Legend Titles.
Subscrip/Superscript in Excel pPot Legend Titles.
(OP)
Is it possible to use subscripts/superscripts in excle plot legend titles. I can do this in the axis titles but excel is not allowing me to do so in legend titles.
Nodal DOF
Nodal DOF





RE: Subscrip/Superscript in Excel pPot Legend Titles.
RE: Subscrip/Superscript in Excel pPot Legend Titles.
Hi NOdal DOF:
With prost's idea of taking a picture ... you can use subscript/superscript in the source items themselves, then take a picture of the collection of those items by ...
1) doing EDIT|Copy
2) then while holding the SHIFT key do EDIT|Paste PictureLink and use that picture for LEGEND
Using PictureLink, if you make a change in the SourceData for the Chart, the LEGEND Items will be automatically updated.
The same concept can be used for using subscript/superscript etc. for Chart TITLE also.
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
RE: Subscrip/Superscript in Excel pPot Legend Titles.
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Subscrip/Superscript in Excel pPot Legend Titles.
I am unfamiliar, never heard of even, the use of ASCII CHAR functions in the series label. You mean in the little box that is identified as "Name" in Source Data/Series tab? If there is anything there at all, it might look like Name: ="a2" when I would like to see it written "a(superscript 2)", that is, "a" with a superscript of 2 to indicate a-squared. Hope it is clear. Is that where the CHAR(178) should be written? So how should I have written 'a-squared' in my Name: input box?
This sounds like a VERY powerful capability that I am missing now. Please give an example! Thanks.
RE: Subscrip/Superscript in Excel pPot Legend Titles.
=CONCATENATE("A",CHAR(179))
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Subscrip/Superscript in Excel pPot Legend Titles.
Man that works great! Thank you so much, this made my day (we've been trying to do this for years).
RE: Subscrip/Superscript in Excel pPot Legend Titles.
I never tried pasting a picture into a chart. I typically copy and paste part of the the title. This provides a text block that can edited. The insert symbol, font functions, and format-text-box work will with this. It takes some trial and error to figure out. If the cursor is in the text, the font can be changed. If the text box is highlighted without the cursor in the text, more things can be changed (borders, backgrounds, etcetera) The block can be dragged over the legend.
RE: Subscrip/Superscript in Excel pPot Legend Titles.
don't follow you. Where am I when I am typing A(alt 0179)?
RE: Subscrip/Superscript in Excel pPot Legend Titles.
You type A and then while holding the ALT Key, key-in 0179 on the numeric key-pad and you will get ...
A³
I hope this helps ... if I misunderstood you, my aplogies!
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
RE: Subscrip/Superscript in Excel pPot Legend Titles.
"E=mc2"
as your title, you type the four characters
E=mc
then you depress the Alt key and hold it down while you type the four digits 0178 on the numeric key pad. When you then undepress the Alt key, you will be looking as a superscripted 2.
This is not an Excel feature. It is inherent in Windows, and can also be used in a spreadsheet cell, a word processing document, or even a reply to an ²Eng-Tips² query (I think).
Heaps more useful characters can be created this way: type "ansi character set" into a search engine to find the full list, or go to
http://www.cyrillic.com/3dkbd/ansitable.html
(which was the first one that G***le threw up a minute ago).
RE: Subscrip/Superscript in Excel pPot Legend Titles.
BTW, putting a sub or superscript in the axis title is easy, just type all the text in the axis title, highlight the text you want to subscript, then Select Format/Axis title and select 'subscript' in the Format window that pops up. So that was never the challenge--the challenge comes from trying to get the legend to look like you want it to look.
RE: Subscrip/Superscript in Excel pPot Legend Titles.
Instead of the formula previously given, type A<ALT>0179 in the legend cell. You MUST use the numeric keypad to type the numbers, the keycodes only work with the pey[pad keys.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Subscrip/Superscript in Excel pPot Legend Titles.
thanks, got it now! The hint about the numeric keypad was 'key' (pardon the pun).
RE: Subscrip/Superscript in Excel pPot Legend Titles.
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Subscrip/Superscript in Excel pPot Legend Titles.
RE: Subscrip/Superscript in Excel pPot Legend Titles.
Thanks a lot.
Nodal DOF
RE: Subscrip/Superscript in Excel pPot Legend Titles.
Have you tried using Character Map? I think it's somewhere in Accessories, but the easiest way to access it is by clicking Start->Run and typing in "charmap". There you can view all of the characters available in each font. You can copy characters from there and then paste them wherever you want. Many fonts have characters available for use that can't be accessed using the "Alt" method. For example, the following characters were all copied from Character Map and pasted here:
? ???????????
RE: Subscrip/Superscript in Excel pPot Legend Titles.
RE: Subscrip/Superscript in Excel pPot Legend Titles.
RE: Subscrip/Superscript in Excel pPot Legend Titles.