Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i show the values on my chart with out clicking the values on data points in expressions tab.
Thanks
Madhu
You can use show value attribute expression and write the same expression label there
public sub setnumbersOnChart()
set MyGraph= ActiveDocument.GetSheetObject("CH02")
set MyGraphProp= MyGraph.GetProperties
set MyExpsToggle = MyGraphProp.Expressions.Item(0).Item(0).Data.ExpressionVisual
if MyExpsToggle.NumbersOnBars = False Then
MyExpsToggle.NumbersOnBars = True
else
MyExpsToggle.NumbersOnBars =false
End if
MyGraph.SetProperties MygraphProp
End sub
u can try this u can get Tool---- Edit Module
Human being made many things we can fly in the aeroplane(tresesco)
Thansk and regards
Madhu