I was struggling to show different charts when clicking on gauges for a dashboard with the ajax client and layers. There are some posts on working with layers that works fine in the IE-plugin client. But it does not work in the Ajax client.
This syntax goes like this - showing Chart1 over Chart 2:
So I tried to find a solution with hiding / showing the charts when clicking. There are plenty examples for text-boxes but this does not work for charts. And I had trouble finding a solution for charts - also in the API-guide.
This syntax is like this for showing a box and does not work for charts:
set LB = ActiveDocument.GetSheetObject("LB01")
boxprop.Layout.Frame.Show.Always = false
boxprop.Layout.Frame.Show.Expression.v = "1=2"
After some work and tests I found the macro syntax that works.