×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Subscrip/Superscript in Excel pPot Legend Titles.
6

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

RE: Subscrip/Superscript in Excel pPot Legend Titles.

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"!

RE: Subscrip/Superscript in Excel pPot Legend Titles.

2

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.

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

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.

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.

RE: Subscrip/Superscript in Excel pPot Legend Titles.

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

RE: Subscrip/Superscript in Excel pPot Legend Titles.

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.

RE: Subscrip/Superscript in Excel pPot Legend Titles.

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

RE: Subscrip/Superscript in Excel pPot Legend Titles.

Quote:


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



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.

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

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.

RE: Subscrip/Superscript in Excel pPot Legend Titles.

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: Eng-Tips.com Forum Policies


RE: Subscrip/Superscript in Excel pPot Legend Titles.

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

RE: Subscrip/Superscript in Excel pPot Legend Titles.

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?

RE: Subscrip/Superscript in Excel pPot Legend Titles.

(OP)
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

RE: Subscrip/Superscript in Excel pPot Legend Titles.

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:

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

RE: Subscrip/Superscript in Excel pPot Legend Titles.

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

RE: Subscrip/Superscript in Excel pPot Legend Titles.

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

RE: Subscrip/Superscript in Excel pPot Legend Titles.

It works just fine for me (XP Pro, Office 2k3).  You do have to make sure that the font selected in Character Map is the same as the format of the cell in Excel.  Some fonts have a much more limited set of characters than others.  You also have to double-click the character in the Character Map grid (or click the "Select" button) to place it in the little text box before you can copy it.  Just choosing a characater from the grid and using ctrl-c doesn't copy it.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources