Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?????
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.
Thanks for the reply but if i want it to do for 2 expressions
Item(0) indicates the first expression. Use line 3 twice, once for each expression.
Kiran Rokkam.