This content has been marked as final. Show 4 replies
set expr2 = cp.Expressions.Item(1).Item(0).Data.ExpressionVisual
expr2.Label.v = "UOM"
expr2.(**** need help for Total Mode default setting change *****)= 'No Totals'
set dims = cp.Dimensions
dims(0).Title.v = "CUSTOMER"
dims(1).Title.v = "LOCATION"
dims(2).Title.v = "ITEMNUMBER"
I am trying to change the Total Mode setting in Straight Chart Properits to 'No Totals' instead of 'Expression Total' as default by macro. Could someone fill the third line mentioned above?