Sure, you just have to keep track of which axis your XY series is plotted
on, so the labels go where you want them to go.

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


"djdwwoug" wrote in message
...
Thanks, would this work if there is a Primary and secondary axis? I tried
your suggestion but it did not work. anymore suggestions ?

"Jon Peltier" wrote:

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"""