How to Hide Zero Data Labels in Bold Reports Charts

In Bold Reports®, you can hide zero values in chart data labels by applying a custom format to a series. This helps keep charts less cluttered so readers can focus on nonzero values, while leaving the underlying data unchanged. Check the format string’s effects on decimal precision and negative values before using it.

Step-by-Step Instructions

Step 1: Access Chart Properties

Select the chart and open its Properties panel.

1. Select the chart you want to modify.
2. In the configuration panel, click the Properties icon.
3. Under Basic Settings, locate Choose Series and click the Edit (pencil) icon next to the series you want to format.
   
   

Step 2: Apply a Custom Format to the Data Labels

1. In the Series Property dialog, open Data Label Settings.

2. Ensure Show Data Label is enabled.

3. In Format, enter:

   0;(0);' '
   

   This format displays positive values as whole numbers, negative values in parentheses, and zero values as a blank space. Because it uses 0 rather than a decimal format, it rounds fractional values to whole numbers. If you want to preserve decimal places while hiding zero, you can try this alternative:

   #,##0.##;-#,##0.##;''
   

   The alternative is intended to show up to two decimal places, use a minus sign for negative values, and show zero as blank. Its behavior should be tested in your Bold Reports version and chart before use.

4. Click OK to save the changes and close the dialog.
   

   

Step 3: Preview the Results

1. Click Preview on the top toolbar.
2. Confirm that zero labels are hidden and that positive, negative, and decimal values display as expected for the format you selected.
   
   

Related Articles

• How to Format Chart Labels to Display Values in Thousands as ‘K’
• How to Display Percentage and Label in a Column Chart
• Displaying Labels Outside Chart in Bold Reports
• How to Display “No Data” Message for a Data Region