Changing the font for part of an axis label, not the whole label.

Changing the font for part of an axis label, not the whole label.

Post by YW15ND » Wed, 20 Jan 2010 09:15:01


Hello,
I have axis labels that need to be partly in italics, and partly not in
italics.
My question is similar to one posted three years ago that if it was
resolved, the solution didn't appear online. (See below, and responses in
the database from James Silverton and Andy Pope).
I am using Excel 2007.
The usual ways to adjust font change the font of the whole axis label. I
need to change only part of each label on the axis. How can I do this?
Thank you.
Amy


Subject: Re: symbol font in chart doesn't appear 6/19/2006 6:00 AM PST

By: Khoshravan In: microsoft.public.excel.charting


Dear Andy
Thaks. I have both English word and Greek letters. Changing the font,
changes all of them. I don't have control over part of it. IS there any
solution?
--
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan
 
 
 

Changing the font for part of an axis label, not the whole label.

Post by Andy Pop » Wed, 20 Jan 2010 18:29:07

Hi,

You can not individual format axis labels.
You can use a dummy series to mimic the axis labels by using data labels
displaying category labels.
Even then to get a mixture of italic and non-italic characters within the
same label you will need to manually edit/format the text. Or use vba code.

http://www.yqcomputer.com/

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.yqcomputer.com/