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

B

Bernard Liengme

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
 
S

ShaneDevenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Y-axis values correspond to x- axis value 1
Use text descriptors as Y axis units 1
Scatter chart with categories on x-Axis 2
Excel 2010 - Line Chart with Mulitiple Data Sets 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
scatter plot 2
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Using the full width of an Excel chart with two Y-axes 2

Top