Ho wto display text instead of blanks in bar chart?

[#1]

Hi,

I have Bar chart which displays count of Pass and count of Fail.

for now I have only Pass data. so, in Fail data instaed of blanks how can I show 'There are no failures' . Please can anyone suggest me.

I tried Error Message caption but it is not workign for this requirement.

Thanks.

[rustyfishbones]

The text object is not disabling, you need to set the object to Top

[#3]

please see attached.

[PrashantSangle]

Hi,

I am not sure but this example will help you.

[#5]

Perfect Thanks.

[manojkulkarni]

Instead of adding text box object you can achieve by using 'Text in Chart' functionality provided.

Add : =IF(Count({<Result={'Fail'}>} Distinct Reference) = 0,'No failure',0)

[christophebrault]

Hi,

You can also do something like this :

[#8]

Thanks. That's really good.