Subscrip/Superscript in Excel pPot Legend Titles. 6

[nodalDOF]

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

 

[prost]

I hope some of the pros give you a better way that we do it--brute force; create an image of the legend with the subscripts, etc. you need. For instance, in Microsoft Paint, create a bitmap, you can create text, symbols, etc. As I said "brute force"!

 

[yogia]

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

 

[joerd]

Remember that you can use the full ASCII set of characters in your series label, so if you just need squares ² or cubes ³ just use CHAR(178) or CHAR(179). Degrees ^o are CHAR(186).

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[prost]

joerd
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.

 

[IRstuff]

Something like this in the cell referenced by the legend:
=CONCATENATE("A",CHAR(179))

TTFN

FAQ731-376

 

[prost]

As Ken Wilson, former voice of the St. Louis Blues used to say "Oh Baby!"

Man that works great! Thank you so much, this made my day (we've been trying to do this for years).

 

[wannabeSE]

For the ASCII characters, I hold the alt key down and type the code. ALT 0179 --> ³ It works in the legends without using the CONCATENATE and CHAR functions. Just type A(alt 0179) to get A³. At one time, I tried using cell references in the legend with mixed results. I think it kept Greek characters intact but the subscripts/superscripts were displayed in full-sized font.

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.

 

[prost]

wannabeEIT
don't follow you. Where am I when I am typing A(alt 0179)?

 

[yogia]

wannabeEIT
don't follow you. Where am I when I am typing A(alt 0179)?

Hi prost:

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

 

[Denial]

To put it slightly differently, when you are typing text into the text box for the axis title, and you want to have
"E=mc²"
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).

 

[prost]

I am still not doing it correctly. I tried two places. I have the chart in a separate window. I select the axis title directly in the window. Hitting 'alt' button only gets me a noise from the laptop, indicating I have made an improper selection. Next I tried to go to Chart Options window, put my cursor in the 'Category X axis', if I hit the Alt button, I get the very same 'error noise' from my laptop. So I still don't follow you, where I am supposed to be in the Excel for this to work. Sorry.

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.

 

[IRstuff]

No, go back to the cell referenced by the legend.

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

 

[prost]

IRstuff:
thanks, got it now! The hint about the numeric keypad was 'key' (pardon the pun).

 

[joerd]

You're welcome.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[prost]

Anybody have an idea how to put mix of Greek and Latin characters in Legends? The Concatenate function works very well with the ASCII character set, which itself seems to be limited to Latin characters, and some non English characters that look Latin but have various (diacritical) marks above the letters, to accomodate non English languages. The ASCII set doesn't look big enough to accommodate Greek letters. Any ideas for extending the ASCII character set, or accessing a different character set that includes Greek letters?

 

[nodalDOF]

Thank you all for your valuable information. I lost track of this thread as i got it done in MATLAB. Any way i can use this stuff next time i do the plots.

Thanks a lot.

Nodal DOF

 

[handleman]

Prost,
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:

? ???????????

 

[handleman]

That's odd. They showed up correctly when I previewed, but the post itself just shows ???????? for me now.

 

[prost]

Grabbing characters off of "Charmap" doesn't seem to work in Excel at all, handleman.