Thread: Custom Format Y-axis; '$1.6 K' ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Custom Format Y-axis; '$1.6 K' ?
On either the y-values on the worksheet or the y-axis, use a custom format
such as #.0, "K"
Need this in VBA? Just record a macro as you do it.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Boswell" wrote in message
...
What code sequence do I choose, (edit), to achieve this?
Boswell


Reply With QuoteReply With Quote