Monday, June 12, 2023

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.

No comments:

Post a Comment