Display Y Axis Label in Millions or Billions

If you're dealing with "big" data and charting it, you'd want the labeling to reflect it in words with the shortened numbers. Imagine subjecting your audience to reading the axis labels in the billions like 1000000000. It's a big cognitive load to manually count those zeros and figure out if it's a billion or ten billion. Make some shorthand notation for your audience so they won't hate you. This is actually fairly simple to do and I'll show two ways it can be done.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[jobaoyefusi]

Thank you!!!!
You can add a dollar sign too right after the outer square bracket if you want 😊
Also how did you remove the first zero on the y axis??

[willc]

How do I display zero at the bottom of the graph?
"M";#, ###, "K"
^that works fine except the bottom axis displays a "K" instead of 0
"M";#, ###, "K";#, ### "0"
^that formula replaced all "K"'s with "0"

[venelinkabakchiev]

For the "B" for Billions on the Y axis I click on "Add" but nothing happens. Any ideas why?

[григорийНиколаев-кх]

Thanks. But format code semms not working in 2016 Excel..

[therihannafucker]

Saved my day with the "display unit " feature. Thanks my man!

[samirpatel]

Good one - only the format seems to work in office 365

[alexigs]

How do I do that if I want the currency to appear?

[alirezamogharabi]

Thanks, I have a question!
how can i extrac only numeric word from a complex text in a cell like this:
abcd 1234 ddsadh dhdhdb

[aishvaryanarain]

how to write log axis to 10^1....format

[potatus]

Great vid! But i cant stand your lip smacking sounds everytime you speak ugggh