| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Axis Label Color
If I have a list of X-Axis labels, how do I go about changing the formatting
of a couple of the labels without changing the rest? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Axis Label Color
hi,
one way. while holding down the control(Ctrl) key, with the mouse, click each lable you wish to reformat. then right clickformat cellselect new format or on the menu bar formatcellsselect new format. "Scott" wrote: If I have a list of X-Axis labels, how do I go about changing the formatting of a couple of the labels without changing the rest? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Axis Label Color
I tried to hold down the control key and click the axis labels, but it will
not let me select individual labels. Any more suggestions? "FSt1" wrote: hi, one way. while holding down the control(Ctrl) key, with the mouse, click each lable you wish to reformat. then right clickformat cellselect new format or on the menu bar formatcellsselect new format. "Scott" wrote: If I have a list of X-Axis labels, how do I go about changing the formatting of a couple of the labels without changing the rest? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Axis Label Color
hi, what are you calling a lable.
regards FSt1 "Scott" wrote: I tried to hold down the control key and click the axis labels, but it will not let me select individual labels. Any more suggestions? "FSt1" wrote: hi, one way. while holding down the control(Ctrl) key, with the mouse, click each lable you wish to reformat. then right clickformat cellselect new format or on the menu bar formatcellsselect new format. "Scott" wrote: If I have a list of X-Axis labels, how do I go about changing the formatting of a couple of the labels without changing the rest? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Axis Label Color
Axis tick labels cannot be formatted individually, other than to a tiny
extent using custom number formats: http://peltiertech.com/Excel/NumberFormats.html To gain control over axis tick labels, replace them with a hidden series and data labels from that series: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html http://peltiertech.com/Excel/Charts/ArbGridLabel.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "FSt1" wrote in message ... hi, what are you calling a lable. regards FSt1 "Scott" wrote: I tried to hold down the control key and click the axis labels, but it will not let me select individual labels. Any more suggestions? "FSt1" wrote: hi, one way. while holding down the control(Ctrl) key, with the mouse, click each lable you wish to reformat. then right clickformat cellselect new format or on the menu bar formatcellsselect new format. "Scott" wrote: If I have a list of X-Axis labels, how do I go about changing the formatting of a couple of the labels without changing the rest? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value axis label cuts off | Charts and Charting in Excel | |||
| Y-axis label Bug | Charts and Charting in Excel | |||
| Y-Axis Label | Charts and Charting in Excel | |||
| Color of a particular label on the Axis | Charts and Charting in Excel | |||
| how do i label the axis? | Charts and Charting in Excel | |||
Hybrid Mode
