Hide Zero Values In Data Labels

less than 1 minute read

So you have a 0% value on one of your data labels and want to hide it?

The quick and easy way to accomplish this is to custom format your data label.

  1. Select a data label.
  2. Right click and select Format Data Labels
  3. Choose the Number category in the Format Data Labels dialog box.
  4. Select Custom in the Category box.
  5. In the format code box, enter 0%;-0%; and click Add.
  6. Close out of your dialog box and your 0% labels should be gone.

Tags: interface-formatting

Categories: formulas

Updated: February 16, 2021

Twitter Facebook LinkedIn

1 minute read

Here’s the simple steps to highlight the row and column of the selected cell which can be extremely useful when navigating large sets of data. Here’s a littl…

less than 1 minute read

How it Works Using SEARCH and ISNUMBER When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functio…

1 minute read

Download the example workbook here: calculate-time-between-dates.xlsx

less than 1 minute read

Sample Data Table of Sales

Leave a Comment