A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old January 19th, 2010, 12:15 AM posted to microsoft.public.excel.charting
amy45
external usenet poster
 
Posts: 1
Default Changing the font for part of an axis label, not the whole label.

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: 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


  #2  
Old January 19th, 2010, 09:29 AM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default Changing the font for part of an axis label, not the whole label.

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.andypope.info/charts/hiliteaxislabels.htm

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"amy45" wrote in message
...
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: 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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.