I saw this question somewhere else. You need to hide the regular axis
labels, use an XY series to put points where you need labels (hide the
points if you want), then apply custom data labels to the points to serve as
your tick labels. Use one of these free utilities to apply labels from a
worksheet range to the data points:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"djdwwoug" wrote in message
...
Hello I have a chart on my workbook. I am trying to format the TickLabels
values to
Produce Letters instead on numbers, it only changes two numbers. and then
give a error
if I try to change more than two conditions. any insight into getting all
value on the
TickLabels to change will be appreciated. Thanks

does not work
Selection.TickLabels.NumberFormat = "[=19] ""G""; [=17] ""S"";[=17] ""F"";
"

works !
Selection.TickLabels.NumberFormat = "[=19] ""G""; [=17] ""S"""