how to do this task in chart?

[#1]

Hi all,

I have two list boxes one for Month and another for year. Without selecting the year and month the chart should not show the values. Its showing the error message when month is not selected in the listbox. I want to do both for year and month. Attached the image. In that i had given the condition in the General tab.

ISNum(Year) and ISNum(Months). Its not working.

how can i achieve this. Or Is there any other way to achieve this.

Thanks

Raghu.

[#2 · Accepted solution]

Hello Raghu

Try this: NOT(IsNull(Year)) AND NOT(IsNull(Months))

Regards,

[#3]

Thanks Nigel,

Its working fine

-Raghu