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
 
You must log in or register to reply here.

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

Horizontal axis to the bottom 1
Make Y-axis values correspond to x- axis value 1
How do I put words as the Y axis values? 0
scatter plot 2
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
X Y (Scatter) Chart EXCEL 2007 1
How do give each datapoint a separate name/label in a scatter char 1

Back
Top