Disable expression by a macro

[#1]

Can a expression be disable with a macro???

[spsrk_84]

Hi,

Yes expression can be disabled through macro.

I found this example in the API Guide.Qvw file.

Just go through the sample

//////////////////////////////////////////////////////// Below is the Sample Code which will create a straight table and disable's the first expression//////////////////////////

Set chart=Activedocument.activesheet.createStraightTable

Chart.AddDimension "Customer'

Chart.AddDimension "ProductType"

Chart.AddExpression "Sum(Amount)"

Chart.AddExpression "Count(Customer)'

Set Cp=Chart.GetProperties

Set Expr=Cp.Expressions.item(0).Item(0).Data.ExpressionData

Expr.Enable=False

Chart.Set Properties Cp

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////