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

What code sequence do I choose, (edit), to achieve this?
Boswell

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

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

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
--
Thanks,
Shane Devenshire


"Bernard Liengme" wrote:

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