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.
- Select a data label.
- Right click and select Format Data Labels
- Choose the Number category in the Format Data Labels dialog box.
- Select Custom in the Category box.
- In the format code box, enter 0%;-0%; and click Add.
- Close out of your dialog box and your 0% labels should be gone.
Tags: interface-formatting
Categories: formulas
Updated: February 16, 2021
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