I have created a button to show Null Values.
in my Pivot table however, if i supress Null Values then use the button, it does not show Null.
Is there a global overrride setting for Button Actions on all charts?
No, there isn't. You could try replacing null values with real values in the script so you can actually select them. See this blog post for more information on null handling.
Retrieving data ...