Dynamic Chart Label Million to Billion with Conditional Formatting

You want dynamic labels for your charts or graphs? For example, when showing sales, if it’s over a million bucks you don’t want the chart label to show 7+ digits. You just want it to show something like 1 M. But if it’s less than 1 million, like 500,000 you want it to show 500K. AND you want it to be dynamic cause your data changes so often.
Think you must do this manually? NO!! There’s a way to do it with a custom format hack. I’ve even through in a bonus tip near the end.

📝 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!

🎁 If you find these videos useful and want to support my channel go to

#excel
#msexcel
#doughexcel

[jawedali]

Thanks Doug, that's what i was searching

[aynino]

Thanks for sharing this! Do you know how to deal with negatives in the same chart? I have tried to add severeal other conditions in case of negative in million and it only accepted 3 conditions, not more... Thanks for your help.

[eslamfahmy]

Very helpful, plz share with us the past value which got from M.office

[TripleB-vwob]

So good! Thank you for all of the great excel tips, especially charts.

[ememnyah]

Thanks! Saw this at the right time. What if the numbers are in hundreds of millions to billions?

[samkab]

Please help...I'm using data labels..in label options I'm selecting values from cells..in my data i have zeros and 0.2.. 0.9.. 0.6... 0.3...i want to hide zeros only .. how to do it?