Add line to Combo chart through macro

[jixiaoquan]

Hi ,

In qvw how to create a combo chart and add two expressions,one is bar,the other one is line?

In my QVW like this:

set chart = ActiveDocument.ActiveSheet.CreateBarChart

chart.AddDimension "ID"

chart.AddExpression "sum(Amount)"

set p = chart.GetProperties

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.BckAsBar = false      

expr.BckAsLine = true

expr.BckAsSymbol= true

expr.ShowAsPopup = true

chart.SetProperties p

chart.AddExpression "sum(Amount)"

set p = chart.GetProperties

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

expr.ShowAsBar = true   

chart.SetProperties p

It does not work,

[Anonymous]

Even i have a similar requirement to be achieved in my dashboard.Please help

[tresesco]

Could you explain the situation better? Perhaps, the similar could be achieved using conditional expression in the chart. May be like in attached sample: