Getting symbols in graph legends
Getting symbols in graph legends
(OP)
Hi,
I cannot find a way of getting symbols into the legend box on an excel plot. For example, I wish to name a legend "lambda 1" but want to display the lamda symbol and not the word. I can find ways of getting symbols into the graph title and axix labels, but not the legend. This seems such a simple thing to do that I cant believe its not possible. I keep having to draw a text box onto the graph but this seems a bodge. Any help? Thanks.
I cannot find a way of getting symbols into the legend box on an excel plot. For example, I wish to name a legend "lambda 1" but want to display the lamda symbol and not the word. I can find ways of getting symbols into the graph title and axix labels, but not the legend. This seems such a simple thing to do that I cant believe its not possible. I keep having to draw a text box onto the graph but this seems a bodge. Any help? Thanks.





RE: Getting symbols in graph legends
Click on the specific entry
Change the font to Symbol
TTFN
RE: Getting symbols in graph legends
RE: Getting symbols in graph legends
1) use ascii codes to enter the specidal characters. i.e., for a degree symbol, hold down the Alt key and type 0176 on the numerical keypad (not top row of keyboard). Look up the ascii codes for the extended characters for a font using the CharacterMap app (charmap.exe) that comes with Windows (or look in the Word/Excel help file for the table of ascii codes).
2) Enter the legend into a cell on a worksheet, format it as you want, then link the series label to the cell. You can also use this method to build up a character string for a legend, title, axis title, etc.
RE: Getting symbols in graph legends
I can enter symbols on thier own but I cannot enter them mixed within normal font characters. If you pre-enter the series name in a separate cell then when you select that cell as being the name of the series it standardises the font - i.e. makes it all ariel or times etc. Taking an editing route doesnt work as once the legend is selected and seen on the graph then the ony editing that can be done to it is its size, colour and font etc but only to the entire label - it doesn not allow you to select just a single character for editing.
RE: Getting symbols in graph legends
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: Getting symbols in graph legends