Help with custom format for axis numbers in chart

[karl-eQ]

Hi. I am looking to have a chart axis display large numbers in shortened forms such as "k" and "m" but was having some issues in getting the format code right.

I got as far as using [>999999] #,,"M";#,"K" to get the numbers displaying as K and M however there are 2 issues:

- "0" is displayed as "K" on the axis and I wasn't sure what to add to the code to alter the 0 number

- Once you get to 1M there are no decimal places for it so the axis displays as "800K 900K 1M 1M 1M". Is there any way to have it display K as is but change the M to display as 1.0M 1.1M 1.2M etc.?

Is there a better code/method to use altogether perhaps? The numbers on the charts run from about 20k to 5M making it a little awkward to display the numbers well.

Any help would be greatly appreciated. Thanks

Kind Regards,
Karl

[MrShorty]

I will recommend that you refer to this page https://support.office.com/en-us/art...2-09fab54be7f4
It should be as easy as adding another condition for the 0 (<=999??) values, and adding placeholders for the additional decimal places you want to display.

Perhaps [>999999] #.#,,"M";[>999]#.#,"K";0