Skip to Content
author's profile photo Former Member
Former Member

Opening graphs on sequence of button press

Hi Friends,

Thanks for helping me on my other questions

I really need help on this one.

I AM DEVELOPING THIS TO BE VIEWED ON IPAD i.e I AM DEVELOPING USING ONLY MOBILE COMPATIBLE COMPONENTS

here is the scenario

I have 5 Toggle Buttons taking status value as 0->OFF 1->ON

State1,state2,state3,state4,state5.

and two graphs arranged one below another as shown in the image attached

what i am trying to accomplish is depending on the sequence of Button press the graph will be populated

ie if i press state2 first it will open in the first graph ,and state1 second it will open in the second graph

and a clear button to reset every thing .

and then if i press state4 it will open in 1st graph and then press state 5 will open in the second graph.basically i am comparing two charts

i am using this formulae to populate the first graph

=IF(AND('Push Buttons'!$A$1=0,'Push Buttons'!$B$1=1,AND('Push Buttons'!$A$1=0,'Push Buttons'!$C$1=1,AND('Push Buttons'!$A$1=0,'Push Buttons'!$D$1=1,AND('Push Buttons'!$A$1=0,'Push Buttons'!$E$1=1)))),West!B2)

and this formulae to poulate the second graph

=IF(AND(F2<>"",OR('Push Buttons'!B1=1,'Push Buttons'!C1=1,OR('Push Buttons'!D1=1,'Push Buttons'!E1=1))),B2)

but its not working

can u suggest any thing .

Thanks & regards

Gaurav Tilara

region.JPG (90.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 07, 2013 at 11:42 AM

    okk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 07, 2013 at 12:33 PM

    Hi,

    As I said before, I think you are making your life hard for no reason by trying to achieve this using push buttons for this. The idea is to have a fast dashboard which looks good and it's easy to use by someone who uses it for the first time. By overcomplicating things you don't thick any of these three boxes.

    How I suggest you should design this (if you don't want to plot the data on just 1 chart) is by divding the screen into 2 (put a vertical line in the middle). On the right you will have one chart and one combo box, on the left one chart and one combo box. It's simple and it does the job.

    Regards,

    Matt

    PS: I have changed my privacy settings so you can now contact me via email.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.