Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way chart Activation on Selection of fields in another chart either through macro.
john
A common way to do something like this is have the chart show conditionally based on a variable. When the condition is met, the chart will display. This concept I have done through the use of text boxes and buttons, using actions
follow the thread below - it hides/shows charts based on slections (the condition is based on what is selected0
I tried this with conditional display, but the problem here is there are nearly 25 selections each in a different dimensions
writing conditional expressions would be difficult
Ex:
if (getselectedcount(A) >0 and getselectedcount(B)=0 so on...
how many different charts are you wanted to activate/deactivate?
from your last post it sounds like it is based on a combiantion of what is selected?
there are 5 charts, yes its a combination.
any chance of posting the application?
how many different combinations for each chart?
sure will do that . I will post sample copy