LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default Excel 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"""

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TickLabels djdwwoug Charts and Charting in Excel 2 August 30th 07 12:42 PM
Chart Titles not showing in excel chart Greg_tnwre Excel Discussion (Misc queries) 1 July 28th 06 05:36 PM
Chart Titles not showing in excel chart Window Greg_tnwre Excel Discussion (Misc queries) 0 July 15th 06 03:41 AM
Excel chart - how to assign the file name in the chart title? TGreen Charts and Charting in Excel 1 August 16th 05 10:35 AM
How do I resize a chart in Excel after the chart has been saved... DianaQ Charts and Charting in Excel 2 March 19th 05 05:27 AM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"