Skip to Content
Former Member
Jan 31, 2008 at 02:58 AM

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.