Replace Large Numbers on Excel Chart Axis with M or K Symbols

When making charts in Excel, it's common to to see large numbers, like those in the millions, clutter up the axis.  Wouldn't it be nice to simply abbreviate all those zeroes with the universal symbols K or M instead?  Here's how:
  1. Right click on the chart axis and select Format Axis
  2. In the left list of option in the window that opens, select Number.
  3. In the Category box that appears next, select Custom.
  4. In the Format Code box directly underneath where you highlighted custom, enter the following code in bold exactly as shown [>=1000000]0,,"M";[>=1000]0,"K";0
  5. Click the Add button
  6. Click the Close button.
Ta da! Much easier to read, huh?

No comments:

Post a Comment

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