 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / August 2007Excel VBA Chart 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""" 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 _______ > Hello I have a chart on my workbook. I am trying to format the TickLabels > values to [quoted text clipped - 10 lines] > works ! > Selection.TickLabels.NumberFormat = "[=19] ""G""; [=17] ""S""" Thanks, would this work if there is a Primary and secondary axis? I tried your suggestion but it did not work. anymore suggestions ? > 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 [quoted text clipped - 26 lines] > > works ! > > Selection.TickLabels.NumberFormat = "[=19] ""G""; [=17] ""S""" 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 _______ > Thanks, would this work if there is a Primary and secondary axis? I tried > your suggestion but it did not work. anymore suggestions ? [quoted text clipped - 34 lines] >> > works ! >> > Selection.TickLabels.NumberFormat = "[=19] ""G""; [=17] ""S""" Thanks again, is there anyway I can count the major gridlines so I can Place the labels on each point. because the gridline changes I need to have the labels on the grid lines. each the data changes thr Y axis numbers and the X has dates I want to change the Y numbers to letters is this posiable Dynamically? > 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. [quoted text clipped - 44 lines] > >> > works ! > >> > Selection.TickLabels.NumberFormat = "[=19] ""G""; [=17] ""S""" Use the same axis scale for the series you add to show labels. If G is always at 19, then you place your point at 19 and apply a label of G. If G is not always 19, you change the cell with the value so it keeps track of G's value (or use a clever formula that changes the value appropriately). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Thanks again, is there anyway I can count the major gridlines so I can > Place [quoted text clipped - 56 lines] >> >> > works ! >> >> > Selection.TickLabels.NumberFormat = "[=19] ""G""; [=17] ""S""" Thanks everything works. > Use the same axis scale for the series you add to show labels. If G is > always at 19, then you place your point at 19 and apply a label of G. If G [quoted text clipped - 68 lines] > >> >> > works ! > >> >> > Selection.TickLabels.NumberFormat = "[=19] ""G""; [=17] ""S""" |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.