ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How could insert symbols e.g. micro in chart legend in Excel? (https://www.excelbanter.com/charts-charting-excel/23435-how-could-insert-symbols-e-g-micro-chart-legend-excel.html)

farmash

How could insert symbols e.g. micro in chart legend in Excel?
 
when we make a chart in Excel and chart legends need to have some symbol
character like micro molar, How could we create it, I tried but micro symbole
chane to "m".

bj

Unfotunately I the only way I know is to put what you want in a text box and
past oveer the lable text

"farmash" wrote:

when we make a chart in Excel and chart legends need to have some symbol
character like micro molar, How could we create it, I tried but micro symbole
chane to "m".


Jon Peltier

Micro (µ) can easily be typed by holding ALT down and typing 0181 on the
numeric keypad. This simple workbook lets you see what codes to type for
to get different characters:

http://peltiertech.com/Excel/Zips/ascii.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

bj wrote:

Unfotunately I the only way I know is to put what you want in a text box and
past oveer the lable text

"farmash" wrote:


when we make a chart in Excel and chart legends need to have some symbol
character like micro molar, How could we create it, I tried but micro symbole
chane to "m".


bj

This still does not show in the legend box

"Jon Peltier" wrote:

Micro (µ) can easily be typed by holding ALT down and typing 0181 on the
numeric keypad. This simple workbook lets you see what codes to type for
to get different characters:

http://peltiertech.com/Excel/Zips/ascii.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

bj wrote:

Unfotunately I the only way I know is to put what you want in a text box and
past oveer the lable text

"farmash" wrote:


when we make a chart in Excel and chart legends need to have some symbol
character like micro molar, How could we create it, I tried but micro symbole
chane to "m".



Jon Peltier

You type it as part of the series name, either in the cell used for the name, or in
the Name entry box in the Source Data - Series dialog.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

bj wrote:

This still does not show in the legend box

"Jon Peltier" wrote:


Micro (µ) can easily be typed by holding ALT down and typing 0181 on the
numeric keypad. This simple workbook lets you see what codes to type for
to get different characters:

http://peltiertech.com/Excel/Zips/ascii.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

bj wrote:


Unfotunately I the only way I know is to put what you want in a text box and
past oveer the lable text

"farmash" wrote:



when we make a chart in Excel and chart legends need to have some symbol
character like micro molar, How could we create it, I tried but micro symbole
chane to "m".





All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com