Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
TickLabels
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""" |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
TickLabels
You can hide the regular ticks, and use an XY chart and its data labels to
apply custom labels: http://peltiertech.com/Excel/Charts/ArbitraryAxis.html http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html - 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""" |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
TickLabels
Thanks this is what I was looking for.
"djdwwoug" wrote: 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""" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|