Macro

[#1]

Hi Guys

I am adding the expression dynamically usng macro in a bar chart now i want to set the property "valuesondatapoints"

can anyone please help me with this?????

[#2]

Use the below:

Set chart = ActiveDocument.GetSheetObject("CH01")
Set p = chart.GetProperties
Set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual
expr.ShowAsTextInChart = TRUE'FALSE to hide

Kiran Rokkam.

[#3]

Thanks for the reply but if  i want it to do for 2 expressions

[#4]

Item(0) indicates the first expression. Use line 3 twice, once for each expression.


Kiran Rokkam.