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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|