cancel
Showing results for 
Search instead for 
Did you mean: 

Remove 0% From Chart Display

Topic

Times where there is 0 information, this will help suppress the 0s or blank data in the output document.

This works in both Word and Excel. Instructions below are for a Word output template. (Not the Excel sheet being used as middleware). You could also use this if you had an Excel output.

User-added image
 

Instructions

Open your Word template and navigate to the charts where being brought in from Excel.

Right click on one of the values in the chart > Select Format Data Labels
User-added image

Expand the Number section > Under Category select Custom > In Format Code box we used 0%;-0%;
Click Add

User-added image
Remember to Save your document and replace it in your Document Package.

User-added image

 

Labels: (2)
Version history
Revision #:
10 of 14
Last update:
‎08-26-2019 11:01 AM
Updated by: