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!

hi,
one way. while holding down the control(Ctrl) key, with the mouse, click
each lable you wish to reformat.
then right click>format cell>select new format or on the menu bar
format>cells>select 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!

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 click>format cell>select new format or on the menu bar
> format>cells>select 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!

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 click>format cell>select new format or on the menu bar
> > format>cells>select 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!

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" <(E-Mail Removed)> wrote in message
news:453DEB35-7080-498D-BAD9-(E-Mail Removed)...
> 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 click>format cell>select new format or on the menu bar
>> > format>cells>select 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!