we have multiple charts in one of Revenue trends tab of an application which currently has been minimised and kept. The user wants to clear the existing chart and launch a another chart by click of a button.
I summary he wants buttons to provided for each chart and by clicking it the earlier chart displayed should get cleared and new chart should get launched.
If I understood you properly, you have several charts minimized, some selections could be done, and you want to create a button to clear selections and restore one of the several charts you already have minimized.
You can try with
sub ShowChart ActiveDocument.GetSheetObject("CHXXX").restoreend sub
where CHXXX is the Object ID of the chart you want to restore. You may check allow objects to "Auto Minimize"
If all of those charts are on a single sheet then you can mark the check boxes "Allow Minimize" AND "Auto Minimize" on those objects you want to treat like this, when you double click on one of the minimized charts it will automatically minimize the active chart and maximize the new chart.
Thanks for your suggestion. There is one more requirement here. The user do not want the chart displayed anywhere in the tab when minimised.
For example we have charts A,B,C,D and E
The user wants 5 buttons provided in the name of each chart and by click of button the chart associated with that button should be launched. He does not want the charts minimised to appear in the application.
in the action part you can enter more than one action, first restore object, then set variable, then minimize object and set variable again. So you define by first click on the button: restore objekt, second click: minimize object!
Did you try by having a list box with Table named as "Visiblity" and the value "visible". Then add a variable(variable1=1) in the document. If the user click the visiblity, so the chart will be opened else hidden. Not even displayed in the Sheet.
For this you need to add the variable for every chart Layout and the value also with the condition. Ex: = not IsNull(Visiblity) and variable1=1.
.png "Miguel_Angel_Baeyens"){kind=avatar}
