No data error

[prma7799]

whenever i click on some chart if the data is not there it should  throw error ...  how to do it

[renjithpl]

May be like one in this attachment you can try... Just an idea..

[flipside]

That's one way to do it, but you can also set a custom error message in the chart object itself. Go to Calculation Condition on the General tab of the object's properties and enter (eg) =Sum(Sales) >0 then click Error Messages button.
Select Calculation condition unfulfilled and the custom message then OK. (Ensure the Show option of the object on the Layout tab is set to Always).