Excel Tip: Abbreviate Large Chart Axis Numbers

Charts are important way of summarizing data in Excel.  For them to work best, they need to be uncluttered.  One way to clean up a chart is to replace large numbers with an abbreviated version.  For example, you could replace 1,600,000 with 1.6M.

To do that, right-click on the chart's axis and select Format Axis.  Then click on Number in the dialog's left column and add this code in the Format Axis's Custom section:

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


If you're curious how Custom Formats work in Excel, check out these these great articles on the topic:

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.