Hi i was wondering if there is a way i can include to the right of my graph a user expression picker?
My graph has 3 expressions and i was hoping to include to the right 3 radio buttons/tick boxes (1 for each expression) which would allow the user to select which expression/s to include on the graph.
Hi! I solve almost same problem. First, create all expressions, Then, create buttons, and macros for each button. Macros will activate or deactivate expressions Look at my example, I create macros and put it in button. It deactivates first three expressions and show just 4 expression. You can play with it to solve your problem
sub expressBt06 set vGraph = ActiveDocument.GetSheetObject("CH17") set vGetProp = vGraph.GetProperties set vExpr0 = vGetProp.Expressions.Item(0).Item(0).Data.ExpressionData set vExpr1 = vGetProp.Expressions.Item(1).Item(0).Data.ExpressionData set vExpr2 = vGetProp.Expressions.Item(2).Item(0).Data.ExpressionData set vExpr3 = vGetProp.Expressions.Item(3).Item(0).Data.ExpressionData