How to add and remove expressions from line chart dynamically

[#1]

How to add and remove expressions from line chart dynamically

[its_anandrjs]

Hi,

See the attached sample file how to use dynamic epression it will explain you.

Let me know about this

Rgds

Anand

[#3]

Trigger the below macros accordingly.

set chart = ActiveDocument.GetSheetObject("CH01")

chart.AddExpression "sum(sales)"

set chart = ActiveDocument.GetSheetObject("CH01")

chart.RemoveExpression "sum(sales)"

Regards,

Kiran.