I am posting a test application for both error message and calculation condition of chart.
This can be done by changing the Error Message settings in the charts.
you can see in attached application, i have given a calculation condition. if that fails, i changed my default Error Msg settings to "No Data to Display".
To change Error Message, Go to Properties ---> Error Msg ---> Custom Error Msg . Type your custom msg.
Try to select 'CompanyZ' in my attached application from Company_Name list box.