Dynamic Number Format
Excel Tips and Tricks

Dynamic Number Format for Millions and Thousands

Many times, when we create a chart and our numbers are quite big then our data labels on the chart are not proper readable. In that case we can change the number format of data label of the charts in millions or thousands according to our numbers.

To change the number format of data labels just right click on Chart and click on Format data labels. Go to the numbers and put the 0.0,,“M” in Format Code box.

Number format of data labels
Number format of data labels

Change the Vertical Axis number format also. Right click and click on Format axis. put the 0.0,,“M” in Format Code box and click on add.

Axis number format
Axis number format

Revenue format will be changed on the chart but in excel table it will be still old one.

Format changed on the chart
Format changed on the chart

You can change the number format on excel table also. To change the number format dynamically in millions and thousand you use below custom format.

[>=1000000]0.0,,"M";[>=1000]0.0,"K";0

 

Dynamic Number format
Dynamic Number format

 

Click here to download the Practice file-

Watch the step by step video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com