Creating a template to use with basic chart but when certain Xaxis labels
contain specific values that might show in certain data sets, I'd like to
either change the font color or use the interior colorindex property.

In other words,

a 1
b 2
c 3

But when the category values are displayed - I'd like the letter b to be in
blue.

I'm already scanning the data and modifying the color of the datalabel font
and the correlated bar chart but wanted to also change the category label.

Thanks in advance...

Any chance this property is available?

You can't format axis labels individually, but you can fake it:

Individually Formatted Category Axis Labels -
http://peltiertech.com/WordPress/ind...y-axis-labels/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



AZToad wrote:
Creating a template to use with basic chart but when certain Xaxis labels
contain specific values that might show in certain data sets, I'd like to
either change the font color or use the interior colorindex property.

In other words,

a 1
b 2
c 3

But when the category values are displayed - I'd like the letter b to be in
blue.

I'm already scanning the data and modifying the color of the datalabel font
and the correlated bar chart but wanted to also change the category label.

Thanks in advance...

Any chance this property is available?

Appreciate the response - unfortunately the option suggested would be too
time intensive as the data (literally hundreds of data sets) are just dropped
in by various analysts to a given range and there are certain categories that
management wants to have flagged when and if they show up - and a chart is
subsequently produced and distributed.

The bars and datalabels coloring (using interior.colorindex and
font.colorindex with case statements) are working great but I just couldn't
figure a way without getting errors to utilize the ticklabel formatting to
try to perform similar tasks on the category names.



"Jon Peltier" wrote:

You can't format axis labels individually, but you can fake it:

Individually Formatted Category Axis Labels -
http://peltiertech.com/WordPress/ind...y-axis-labels/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



AZToad wrote:
Creating a template to use with basic chart but when certain Xaxis labels
contain specific values that might show in certain data sets, I'd like to
either change the font color or use the interior colorindex property.

In other words,

a 1
b 2
c 3

But when the category values are displayed - I'd like the letter b to be in
blue.

I'm already scanning the data and modifying the color of the datalabel font
and the correlated bar chart but wanted to also change the category label.

Thanks in advance...

Any chance this property is available?