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

Easy question but I'm stumped - sorry, relatively new user

Post Author: kmham

CA Forum: Xcelsius and Live Office

Say I have 2 objects in XC (let's say Pie Chart 1 and Pie Chart 2). Then I want a Radio control with 2 radio buttons, 1 labeled Show Pie Chart 1 and the 2nd one labeled Show Pie Chart 2.I assume this will probably use dynamic visibility, but I can't figure out how to setup my Excel source file and I also can't figure out how to setup the Radio buttons and whatever else is needed in XC to make this work (Status List, Columns, ...?)Here's what I tried that doesn't work.Cell A1 = 1, Cell B1 = 0Cell A2 = 0, Cell B2 = 1Then I used 2 radio buttons, with Insert Option set to Columns, source data is B1:B2 and insert in range is A1:A2. Then I set each pie chart to 1 for Dynamic Visiblity figuring that when I toggle between the 2 radio buttons that this would toggle between my 2 pie charts alternating between the 2. I can see why it's not working in that the insert in function is always inserting the same 0,1 from B1:B2 into A1:A2, but I don't see what other way I can set this up to make it work properly.PLEASE, PLEASE HELP. I know this is probably super simple, but I need to figure this out asap.Thanks in advance for the help. P.S. As you can tell, I'll need step by step instructions as to how to set this up to work the way I want it to.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 31, 2008 at 09:52 AM

    Post Author: amr_foci

    CA Forum: Xcelsius and Live Office

    my Dear friend,, why u use 4 cells for 2 charts visability,, you can just use one CELL,,

    1 - Prepare ur excel sheet, and add in 2 cells (0,1) say (A1,A2)

    2 - Add "Radio Button" Selector

    3- set the "Radio Buttin" Selector Labels,, from modifying its labesl,, remove the default third one and modify the text of the first 2 values to (Display Chart1, Display Chart2)

    4- select values in insert option

    5- go to source data and select cells (A1,A2)

    6 - go to insert in and choose any cell in the excel sheet say (A3), which will holds 0 or 1 based on ur selection of the radio button

    7 - Add to Charts to the Stage (Chart1,Chart2)

    8 - for Chart1 go to properties - Behavior - Dynamic Visibility and set the "Display Status" to A3, and the "Display Status Key" to (1)

    9 - for Chart2 go to properties - Behavior - Dynamic Visibility and set the "Display Status" to A3, and the "Display Status Key" to (0)

    run things,, hope it works fine with you

    good luck

    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.