Only Show Data Labels in Chart if Value Less than #

[smithad922]

I know I can use the custom formatting for chart data labels to not display values of 0, but is there a way to not show data labels if the value is less than a number, such as less than 0.2? I only want to display values of 0.2 or more.

[sweep]

Hi,

The simplest way is to create a second data series that excludes the values you don't want to show labels for (eg =IF(A1>=0.2,A1,""). Plot this series with no line or marker, but with the labels showing.

[romperstomper]

You can use a custom number format like:

[>=0.2]0.0;