Knowledge base KB0195

How can I hide segment labels for "0" values?

think-cell does not draw labels for segments with a corresponding empty cell in the datasheet or if the corresponding cell contains text. For simple charts, you can simply delete the content of the corresponding cell.

If the chart is complex or the values will change in the future, an Excel data link (see 21. Excel data links) can be used to automatically hide any labels when the value is zero ("0").

  1. Open your data source
  2. Use cell references to read the source data and apply the Excel IF function to replace the value "0" by the text "Zero"

    How to use the IF function to hide zero segment labels?.

  3. Create a think-cell chart using the Excel data link from this data