Character Map

K

k f h

Hi All,

I'm trying to insert a symbol into my charts title. When I click insert the
symbol tab it is greyed out. How do I access the character map from my chart.

Thanks,

kfh.
 
J

Jon Peltier

A chart title is not a rich text box. In fact, it's hardly a text box at
all, because you can't change its height and width. You can't insert
objects into the text. What you can do is type the appropriate character
in the normal font, then select the character and change its font to
Symbol or Wingdings or whichever font has the character you need.

This works with chart titles, axis titles, data labels, and textboxes in
the chart, but unfortunately not with legend entries or axis tick labels.

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

k f h

Hi Jon,

Thanks for that,

kfh.


Jon Peltier said:
A chart title is not a rich text box. In fact, it's hardly a text box at
all, because you can't change its height and width. You can't insert
objects into the text. What you can do is type the appropriate character
in the normal font, then select the character and change its font to
Symbol or Wingdings or whichever font has the character you need.

This works with chart titles, axis titles, data labels, and textboxes in
the chart, but unfortunately not with legend entries or axis tick labels.

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

Nicky

Hi
a similar solution - insert the title charaters and symbols into a
worksheet cell, amd link the chart's title to it eg =Sheet1!$a$1
 
J

Jon Peltier

Which works as long as all characters are in the same font.

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

ewkehl

k f h said:
Hi All,

I'm trying to insert a symbol into my charts title. When I click insert the
symbol tab it is greyed out. How do I access the character map from my chart.

Thanks,

kfh.
 
B

Bob F

In Windows Vista Home Premium, I get a character in the character map for the
division symbol that's inaccurate:

ö instead of the division symbol.

Would anyone have a workaround?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top