I have a spreadsheet in Excel 2013 where I have a pie graph that displays percentages as the data labels. I had a custom format code, 0.0%;-0.0%; ,to hide zeros from the chart, however a request came through to display both percentages AND values. Now my custom format code is not working for the values. The percentages are still hiding the zeros, but there is a "0," that is displayed on the chart now. I've tried a few custom format codes in an attempt to hide these zeros, but nothing I've tried has worked. Any recommendations for hiding zeros when there is more than one label option enabled in the chart? Any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Format Code for Data Labels to hide zeros when both Value and Percentage are selected as Label Options
- Thread starter DimWSH
- Start date
