How to change the current expression of a group by macro?

Ask a Question

Hello,

I have an application with a chart that contains 3 expressions, grouped.

I'ld like to be able to change it by macro.

I tried

set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
set expr = p.Expressions.Item(0).Item(0).Data.ExpressionData
expr.CycleGroup = 1
chart.SetProperties p

but it doesn't change anything.

A workaround I found is to ungroup my expressions and add a condition, linked to field I can change in a list box, but it makes me change a lot of charts, and I have to also make a condition on the display of the list box.

0 Replies