Chart No Data to Display

[#1]

In the attached application I have a chart and when I select July it has no sales so the chart shows "No Data to Display" is there a way I can get the chart to show zero versus saying "No Data to Display".

[Sokkorn · Accepted solution]

Hi sbp,

It sound like customize message <No Data to Display>. Maybe I'm not get your point, but let try this

Right Click on Bar Chart ==> Properties ==> Select General Tab

    1. Calculation Condition : IF(SUM(Sales)=0,0,1)

    2. Click on button <Error Messages> ==> Custom Message and paste =IF(SUM(Sales)=0,'Value is 0')

Check in attached file also.

Do let me know.

Regards,

Sokkorn Cheav

[#3]

Thank you for your help.