PC Review


Reply
Thread Tools Rate Thread

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

 
 
amy45
Guest
Posts: n/a
 
      19th Jan 2010
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


 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      19th Jan 2010
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" <(E-Mail Removed)> wrote in message
news:152C08BA-F07C-4CA9-9983-(E-Mail Removed)...
> 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
>
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the data label position below the chart axis. Laura Microsoft Excel Charting 2 20th Jul 2009 07:32 PM
Programmatically changing MSGraph Y axis label and values off =?Utf-8?B?QmFyYiBSZWluaGFyZHQ=?= Microsoft Powerpoint 2 29th Jun 2007 04:36 PM
Changing the font for a label programmatically Randy Microsoft C# .NET 1 6th Jun 2007 08:29 PM
ONLY PART OF MY TYPED IN Y-AXIS LABEL SHOWS UP ON THE CHART =?Utf-8?B?Y2hyaXN0aW5lU1Q=?= Microsoft Excel Charting 2 21st Jan 2007 06:00 AM
Link Title/Subtitle/X-Axis Label/Y-Axis Label to Cells =?Utf-8?B?RGVidQ==?= Microsoft Excel Charting 3 25th Nov 2004 05:49 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:31 PM.