How to choose 'suppress when value is Null' option in Macro?

[#1]

Dear all,

I want to choose 'suppress when value is Null' option in Macro. How can I write the code?

In Chart properties->Dimensions->Setting for selected dimension------->'suppress when value is Null'

[#2]

here , how to choose the option in macro script.?

[#3 · Accepted solution]

set chart = ActiveDocument.Activesheet.CreateBarChart
chart.AddDimension "ProductType"
chart.AddExpression "sum(Amount)"
set cp = chart.GetProperties
set dims = cp.Dimensions
dims(0).NullSuppression = false
chart.SetProperties cp