Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want change properties for one chart in maximize mode and and normal mode ,different properties like ..i Need to show values on data points in maximize mode ,i don't want to show values on data points in normal mode is it possible?
To add to the above video:
Step 1: Create Chart and List box
Step 2: Add in VB script:
Public Sub SetNumbersOnChart()
Set MyGraph = ActiveDocument.GetSheetObject("CH01")
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
Step 3: Call the above macro when the field of the list box is selected
For this you would have to set a on select Action for that field in document properties. (Screen shots attached)