Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
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
here , how to choose the option in macro script.?
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