Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Subscrip/Superscript in Excel pPot Legend Titles. 6
- Thread starter nodalDOF
- Start date
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"!
-
2
- #3
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
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
-
1
- #4
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 for tips on how to make the best use of Eng-Tips.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
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.
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.
-
1
- #6
-
1
- #8
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.
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.
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
-
1
- #11
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
(which was the first one that G***le threw up a minute ago).
"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
(which was the first one that G***le threw up a minute ago).
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.
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.
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?
- Thread starter
- #17
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:
? ???????????
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:
? ???????????
- Status