Custom Format Y-axis; '$1.6 K' ?

  • Thread starter Thread starter Boswell
  • Start date Start date
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
 
Hi,

1. Right-click the Y axis and choose Format Axis.
2. On the Number tab choose Custom
3. In the Type box enter

$#.0, K

If this helps, please click the Yes button
 
Back
Top