| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Custom Format Y-axis; '$1.6 K' ?
What code sequence do I choose, (edit), to achieve this?
Boswell |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
| hiding % characted in the Y axis using custom format | Charts and Charting in Excel | |||
| Custom X-axis Labels | Charts and Charting in Excel | |||
| Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel | |||
| Custom Value Axis | Charts and Charting in Excel | |||
Linear Mode
