Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to create a Business User button to toggle the 'Suppress Zero Values' option for a chart?
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