Is it possible to create a Business User button to toggle Suppress Zero Values?

Thu, 07 Feb 2013 09:07:26 GMT

Is it possible to create a Business User button to toggle the 'Suppress Zero Values' option for a chart?

Re: Is it possible to create a Business User button to toggle Suppress Zero Values?

Thu, 07 Feb 2013 10:18:36 GMT

yes, but you need to use macro in button trigger

sub Suppress

set obj = ActiveDocument.GetSheetObject("CH01")

set zip = obj.GetProperties

if zip.SuppressZero = true then zip.SuppressZero = false else zip.SuppressZero = true

obj.SetProperties zip

end sub