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

[Former Member]

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.

[Former Member]

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