Yes you can, Goto chart properties and you will find Filter tab in left navigation,select that and specify the filter criteria.Attached is sample screen shot.

No we can not, that is the reason we are geting the values from DB. This is the easiest way which i found for all of them.