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
This is a article attached imageThis is a article attached image

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

This is a article attached imageThis is a article attached image
Remember to Save your document and replace it in your Document Package.

This is a article attached imageThis is a article attached image

 

 

Labels: (1)
Version history
Revision #:
15 of 15
Last update:
3 weeks ago
Updated by:
 
Contributors