Excel Dashboards & Reports For Dummies
Book image
Explore Book Buy On Amazon

There will undoubtedly be lots of numbers on your Excel dashboards. It's important that you format your numbers effectively to allow your users to understand the information they represent without confusion or hindrance. Remember that every piece of information on your dashboard should have a reason for being there.

Here are some guidelines to keep in mind when formatting the numbers on your dashboards and reports:

  • Always use commas to make numbers easier to read. For example, instead of 2345, show 2,345.

  • Use decimal places only if that level of precision is required. For instance, there's rarely a benefit to showing the decimal places in a dollar amount, such as $123.45. In most cases, the $123 will suffice. Likewise in percentages, use only the minimum number of decimals required to represent the data effectively. For example, instead of 43.21%, you may be able to get away with 43%.

  • Use the dollar symbol only when you need to clarify that you're referring to monetary values. If you have a chart or table that contains all revenue values, and there's a label clearly stating this, you can save room and pixels by leaving out the dollar symbol.

  • Format very large numbers to the thousands or millions place. For instance, rather than display 16,906,714, you can format the number to read 17M.

About This Article

This article is from the book:

About the book author:

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel, and has been named Microsoft Excel MVP for his contributions to the Excel community.

This article can be found in the category: