Getting a "delta" symbol in label
joe_...@my-deja.com
it won't let multiple fonts be used within one label, the "delta" from
font Symbol is switched to a "D". So the only way it seems to get
around this is to have a single font with both alphanumeric characters
and Greek letters. And a commonly-used font would be even better.
I found with a font-editing program that Tahoma has Greek letters
included in it also. So, it would seem that this would work, but how do
I get them to show up on screen (and in a chart)? They are not
accessible through normal keyboard use (that I can figure), but opening
up the actual font, I can see them present. How do I use them?
Any help greatly appreciated.
Joe
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
John Walkenbach
characters in a chart's title, axis titles, and data labels. What type of
label are you referrring to?
----- Posted by John Walkenbach of JWalk & Associates -----
----- Visit "The Spreadsheet Page" -----
----- http://www.j-walk.com/ss -----
<joe_...@my-deja.com> wrote in message news:7kos73$jha$1...@nnrp1.deja.com...
Joe
<jo...@j-walk.com> wrote:
>I'm not sure what you mean by a chart label. You *can* format individual
>characters in a chart's title, axis titles, and data labels. What type of
>label are you referrring to?
The labels in question are called "Category (X) axis lables"
I am making a clustered column chart, and these are the column group
labels.
These are read right from the cell. Excel help states:
>Change the font and size of text in a chart
>
>If a chart title or text box is linked to a worksheet cell, you can change
>the formatting of all characters in the title or text box at the same time,
>but you cannot change individual characters.
So my question stands. If I'm still not clear, I'll be glad to send
you (or anyone else) a sample chart.
Joe
André Viergever
Look at tahoma with system tools / special signs : No delta or other
greek symbols!
joe_...@my-deja.com wrote:
>
> I'm trying to put a delta in with normal text in a chart label. Since
> it won't let multiple fonts be used within one label, the "delta" from
> font Symbol is switched to a "D". So the only way it seems to get
> around this is to have a single font with both alphanumeric characters
> and Greek letters. And a commonly-used font would be even better.
>
> I found with a font-editing program that Tahoma has Greek letters
> included in it also. So, it would seem that this would work, but how do
> I get them to show up on screen (and in a chart)? They are not
> accessible through normal keyboard use (that I can figure), but opening
> up the actual font, I can see them present. How do I use them?
>
> Any help greatly appreciated.
>
> Joe
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
André Viergever M.Sc. Director of E*M*A*I*L
=Environment Management And Information Liaison =
PO Box 3010; 2301 DA Leiden, the Netherlands
Tel: ++31.71.5230652 Fax: ++31.71.5230683
vier...@e-m-a-i-l.nu www.e-m-a-i-l.nu
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> EUROSTAT TEPI Project http://e-m-a-i-l.nu/tepi/<
> EnviroLinks: http://e-m-a-i-l.nu/envirolinks/ <
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Victor Eldridge
To display those extra characters on a worksheet, use the Char() function.
Try copying this formula to the first 255 rows of a worksheet.
=CHAR(ROW())
If your delta character appears on row 142 , you could use =CHAR(142)
joe_...@my-deja.com wrote in message <7kos73$jha$1...@nnrp1.deja.com>...
Joe
<vier...@e-m-a-i-l.nu> wrote:
>Tahoma has NO delta!
>Look at tahoma with system tools / special signs : No delta or other
>greek symbols!
I couldn't find any symbols in Tahoma through excel either, but I
downloaded a freeware font editor (called Softy). When I opened
Tahoma up, there were all of the normal characters, but way past them
were Greek letters.
In Softy, the normal characters were mapped from 1-255. I could get
these by holding alt and pressing 0 followed by the 3 numbers. (Ie,
alt 0-1-2-3 gives me a "{"). The Greek letters were mapped way
farther up, delta being at position 916. When I type alt-0-9-1-6 or
alt-9-1-6, I don't get the right character. How do you access these
characters mapped higher up? I looked at purely greek fonts online,
and they have dead key combinations (hitting 2 keys before one
character appears) in order to accommodate the sheer number of
macrons, breath marks, etc associated with the language. And I've
read other foreign fonts work the same way. Is this how I access
these characters within the font?
Or if Tahoma doesn't have them, does any other common font have Greek
letters easily accessible along with all normal alphanumeric
characters? I'm all for the easiest solution.
Joe
G L Hendry
the new Unicode fonts, including Tahoma DO have the basic Greek alphabet
(along with Arabic, Hebrew etc etc).
Look in Word under Insert|Symbol and under Subset "Basic Greek".
These characters are not available in Excel with =Char() and hence the
alt+"number" idea does not work.
I have done a quick and dirty check by pasting the character from Word into
Excel. The cell can then be edited adding "normal" characters. This works
in a bar chart with x-axis labels showing the Greek characters .
One of the Gurus may know how to directly access the Unicode set in Excel.
Hope this helps.
Graham Hendry
Ralph Hancock
André Viergever wrote in message <3770FB04...@e-m-a-i-l.nu>...
>I think the problem lies within softy rather than in Tahoma.
>I know of no font that has the delta among the standard characters.
The latest version of Tahoma includes a full Greek alphabet. This is the
Unicode version of the font. Of course, there are plenty of out-of-date
versions still circulating. I believe that you can get an updated Tahoma
(and Arial, Courier New and Times New Roman) from the Microsoft web site.
Maybe someone else will supply the exact URL. Or try to get it by FTP from
Imperial College (sunsite.ac.uk), which has a Microsoft mirror and is *much*
faster.
Ralph Hancock
<han...@dircon.co.uk>
<http://www.users.dircon.co.uk/~hancock>
G L Hendry
I knew there was a good reason for upgrading! Pity there still isn't an
Insert|Symbol option in Excel!
Graham
...
Joe
>I tried it and it worked for me (using Excel 97 SR1). Just type in a
>capital D and format it for the Symbol font. I was able to have multiple
>fonts in the same line. Just selct the letter and change the font.
The changes do not carry over into the chart x-axis labels. They only
show one font.
Joe
Tushar Mehta
sent to Joe <joe_...@my-deja.com>.]
As John Walkenbach indicated earlier you *can* format individual letters
(Listen to the man. If he doesn't know what he is talking about, who does?).
I've done it for some years now, and I just verified it with a chart's x-axis
label (97SR2). Here's what you need to do: Create the x-axis label. Click on
it. Now click-and-drag so that you select one character. Select Format |
Selected Axis Title... In the resulting dialog box select the specifics that
you want (font, subscript, size, etc.) Close the dialog box and you are all
set.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
--
In article <37726377...@news.pagesz.net>, Joe <joe_...@my-deja.com>
says...
Tushar Mehta
sent to Joe <joe_...@my-deja.com>.]
I understand the problem and I assume you are sure that upgrading to 2000 will
fix. it.
Anyway, with 97 there are two very sloppy (read high-maintenance) ways around
the problem but if the graph doesn't change frequently (ever?) either *may* be
an acceptable solution. I verified both.
Option 1: Remove the category labels, add text boxes with the same content.
Now, you have control over the format of each character in each text box.
Option 2: Leave the category labels as they are. As long as the delta symbol
precedes (or follows) the label, create a separate text box which contains just
the delta character (in the Symbol font) and position it so that the delta is
adjacent to the label(s).
--
Regards,
Tushar Mehta
www.tushar-mehta.com
--
In article <37717459...@news.pagesz.net>, Joe <joe_...@my-deja.com>
says...
> Perhaps that last post was a little vague in what I was calling the
> x-axis label. In my original response to John Walkenbach, I explained
> that "The labels in question are called "Category (X) axis lables".
> I am making a clustered column chart, and these are the column group
> labels."
>
> For example, if you were to make a chart as follows:
>
> | ABC | DEF | GHI
> -----------------
> | 1 | 2 | 3
> -----------------
> | 4 | 5 | 6
>
> and make a "clustered column" (the default chart type when you run the
> wizard), you will see the labels abc, def, and ghi. These are what I
> am trying to change, where I want to add a delta. You can add an
> additional x-axis label which can be formatted as you said, but that
> is not what I am trying to change.
>
> I called these labels "Category (X) axis lables" because that is what
> the chart wizard labels them as. (When you run the wizard and are on
> step 2, click the 'Series' tab, and it is at the bottom.)
>
> So far, it looks like upgrading to Excel 2K is my only solution.
>
> Joe
Ray
capital D and format it for the Symbol font. I was able to have multiple
you can also turn the recorder to see what code is generated if you need
this in VBA.
<joe_...@my-deja.com> wrote in message news:7kos73$jha$1...@nnrp1.deja.com...
Joe
Victor Eldridge
Use the =CHAR() funtion to put the the delta character into a cell.
Obviously that cell must be formatted with your custom font.
The X-axis needs to formatted with your custom font also.
The special character appears on the "Category (X) axis lables".
There is no need to upgrade your version of excel.
Excel 97 handles this with ease.
joe_...@my-deja.com
"Victor Eldridge" <v...@ultratrace.com.au> wrote:
> The X-axis needs to formatted with your custom font also.
> The special character appears on the "Category (X) axis lables".
I do not wish to have everything in my 'custom font' - only the delta.
And since there's not an _easily accessible_ font with Greek and
alphanumeric characters, there doesn't seem to be any way to do it.
Sure, I could make a font with both, but then nobody else could view it.
Thanks anyhow. Time to upgrade!
joe_...@my-deja.com
> Anyway, with 97 there are two very sloppy (read high-maintenance) ways
around
> the problem but if the graph doesn't change frequently (ever?) either
*may* be
> an acceptable solution. I verified both.
Excellent work-arounds. I used the first one. Thanks to all who
helped!
Can someone else verify that in Office 2000 this can be done the way I
originally intended? This gets the job done for now, but I'd like to
double check that it can handle multiple fonts before I buy.